I got one master and two slaves.
- slave01 = replication from master - working fine
- slave02 = server is configured to delay for 345600 seconds (4 days).
The issue is on the slave02 server
Recovery.conf:
restore_command = 'exec nice -n 19 ionice -c 2 -n 7 ../../bin/segment.sh "../wal_archive/%f" "%p" 345600'
At about 10 days ago, I had an issue with my MASTER, and the server had to be restarted.
PROBLEM:
The replication on the slave02 server is not working. When looking the logs, I see:
WAL segment `../wal_archive/00000002000011E800000012` not found
I tried to copy manually that file, from my backups, then I get another error:
Archived WAL segment `../wal_archive/00000002000011E800000012` is newer than the configured delay (345600 seconds)
So it seems the database hasn't been replicated since MAY 17:
on slave02 server:
ls -la /var/lib/pgsql/9.2/wal_archive:
postgres postgres 16777216 May 17 18:16 00000002000011E80000000F
postgres postgres 16777216 May 17 18:18 00000002000011E800000010
postgres postgres 16777216 May 17 18:18 00000002000011E800000011
- Is there anything I can do to solve the problem? Without having to syn all the DATABASE again?