| From: | "ascot(dot)moss(at)gmail(dot)com" <ascot(dot)moss(at)gmail(dot)com> |
|---|---|
| To: | PostgreSQL general <pgsql-general(at)postgresql(dot)org> |
| Cc: | ascot(dot)moss(at)gmail(dot)com |
| Subject: | Enable WAL Archive in Replication server |
| Date: | 2013-08-11 08:32:12 |
| Message-ID: | E7C752E1-9F43-4764-BA31-41E7EC15019D@gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-hackers |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jov | 2013-08-11 11:27:40 | Re: Enable WAL Archive in Replication server |
| Previous Message | ascot.moss@gmail.com | 2013-08-11 08:13:47 | replication server: LOG: invalid magic number 0000 in log file 169, segment 77, offset 4325376 |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jov | 2013-08-11 11:27:40 | Re: Enable WAL Archive in Replication server |
| Previous Message | ascot.moss@gmail.com | 2013-08-11 08:13:47 | replication server: LOG: invalid magic number 0000 in log file 169, segment 77, offset 4325376 |