View Issue Details

IDProjectCategoryView StatusLast Update
0000255My infrastructureGeneralpublic2024-11-16 16:15
Reporterdvl Assigned Todvl  
PrioritynormalSeverityminorReproducibilityhave not tried
Status assignedResolutionopen 
Summary0000255: PostgreSQL min_wal_size seems to be ignored.
DescriptionCompare config files with /var/db/postgres/data16/pg_wal
TagsNo tags attached.

Activities

dvl

2024-11-16 16:15

manager   ~0000342

was size set. Seems I was not propagating the results through to the server.

[16:09 pg03 dvl ~] % sudo cat /usr/local/etc/postgresql.conf.d/postgresql.local.conf                                                                                        

listen_addresses = '10.55.0.34'

ssl = on

ssl_cert_file = '/usr/local/etc/ssl/pg03.int.unixathome.org.cer'		# (change requires restart)
ssl_key_file  = '/usr/local/etc/ssl/pg03.int.unixathome.org.key'		# (change requires restart)
ssl_ca_file   = '/usr/local/etc/ssl/ca.cer'			# (change requires restart)

work_mem = 1MB                         # min 64kB
maintenance_work_mem = 1GB

max_wal_size = 16GB
min_wal_size = 80MB

checkpoint_completion_target = 0.7

client_min_messages = notice
log_min_messages = notice
log_min_error_statement = notice

log_checkpoints = on
log_connections = on
log_disconnections = on
log_duration = on

log_lock_waits = on
log_statement = 'all'

log_timezone = 'UTC'
#datestyle = 'iso, mdy'

timezone = 0

# added for three concurrent restores:

max_connections = 200

Issue History

Date Modified Username Field Change
2024-11-11 15:03 dvl New Issue
2024-11-11 15:03 dvl Status new => assigned
2024-11-11 15:03 dvl Assigned To => dvl
2024-11-16 16:15 dvl Note Added: 0000342