(In a test setup) I can't get pg_archivecleanup to remove WALfiles in 9.3devel. 
(A very similar 
setup in 9.2 works fine).

In 9.3 pg_archivecleanup just keeps repeating lines like:

pg_archivecleanup: keep WAL file 
"/home/aardvark/pg_stuff/archive_dir93/000000000000000000000000"
and later

(and does not delete any files.)

Configuration:

# master  pgsql.93_1/data/postgresql.conf:
data_directory = '/home/aardvark/pg_stuff/pg_installations/pgsql.93_1/data'
listen_addresses = '*'
max_connections = 100
shared_buffers = 128MB
wal_level = hot_standby
synchronous_commit = on
checkpoint_segments = 3
archive_mode = on
archive_command = 'cp %p /home/aardvark/pg_stuff/archive_dir93/%f < /dev/null'
max_wal_senders = 3
synchronous_standby_names = '*'

# slave   pgsql.93_2/data/postgresql.conf:
data_directory = '/home/aardvark/pg_stuff/pg_installations/pgsql.93_2/data'
listen_addresses = '*'
port = 6665
max_connections = 100
shared_buffers = 128MB
wal_level = hot_standby
synchronous_commit = on
checkpoint_segments = 3
max_wal_senders = 3
synchronous_standby_names = ''
hot_standby = on
wal_receiver_status_interval = 59

# pgsql.93_2/data/recovery.conf
primary_conninfo = 'host=127.0.0.1 port=6664 user=aardvark password=sekr1t
application_name=wal_receiver_01'
standby_mode = 'on'
restore_command = 'cp /home/aardvark/pg_stuff/archive_dir93/%f %p < /dev/null'
archive_cleanup_command = 'pg_archivecleanup -d 
/home/aardvark/pg_stuff/archive_dir93 %r'


Seeing that the same setup in 9.2 has pg_archivecleanup deleting files, it 
would seem that some
bug exists but I haven't followed changes regarding WAL too closely.

(My apologies if it's a config mistake on my part after all; but in that case: 
I cannot find it
and would be thankful for a hint)


Thanks,

Erik Rijkers





-- 
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers

Reply via email to