summaryrefslogtreecommitdiff
path: root/etc/postgres/postgresql.conf
blob: 4d7f70363c87596b75897f65cda9d26dad25a7b8 (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
# Connection settings
listen_addresses = ''
unix_socket_directories = '/tmp'

# Logging settings
logging_collector = off
log_destination = 'stderr'
log_statement = 'ddl'
log_line_prefix = ''
log_min_duration_statement = 1000
log_checkpoints = on

# Performance and Development
shared_preload_libraries = ''       # No additional libraries needed
max_connections = 100               # Default connection limit
shared_buffers = 128MB              # Default buffer size

# Development-friendly settings
fsync = off                         # Faster writes (safe for development only)
synchronous_commit = off            # Faster commits (safe for development only)
full_page_writes = off              # Reduce I/O (safe for development only)

# Timezone
timezone = 'UTC'                    # Use UTC for consistency
log_timezone = 'UTC'                # Log timestamps in UTC