now you can only enable WAL archive on the Master server,it will not take effect on replication server.
I can't find the doc which explicit prohibit WAL archive on the replication server,and there are WAL generated in the slave pg_xlog dir with archive_status subdir,so I think this may be a bug. Jov blog: http:amutu.com/blog <http://amutu.com/blog> 2013/8/11 ascot.m...@gmail.com <ascot.m...@gmail.com> > Hi, > > I want to archive WAL log files in the replication server as well, the > postgresql.conf is added with following new lines, after restarting PG, the > /var/pgsql/data/archive/ is still empty after 1 hour: > > > ### new lines added today > # > # to enable the replica as Hot Standby > hot_standby = on > # > # to enable WAL archive (coped from master's conf) > wal_level = hot_standby > max_wal_senders = 5 > wal_keep_segments = 500 > wal_sync_method = fsync > fsync = on > archive_mode = on > archive_command = 'test ! -f /var/pgsql/data/archive/%f && cp %p > /var/pgsql/data/archive/%f' > ### > > ls -la /var/pgsql/data/archive/ > total 8 > drwx------ 2 postgres root 4096 Aug 11 16:12 ./ > drwx------ 3 postgres root 4096 Aug 10 10:59 ../ > > PG: 9.2.4 > OS: Ubuntu 12.04 > > I am new to Streaming Replication, can you please advise why there is no > WAL archive files found in the archive folder? > > regards > > -- > Sent via pgsql-general mailing list (pgsql-gene...@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general > >
