I had the same issue... A slave server had missing wal_files... and it
wasn't synced.
I had to re-sync all the DB, by running the pg_basebackup command
So.. basically, what I did is:
1 - Ensure that the wal_files are being inserted into the slave
2 - Backup the recovery.conf, postgresql.conf
On Wed, Jun 22, 2016 at 12:22 PM, Alan Hodgson
wrote:
> On Tuesday 21 June 2016 19:34:18 Ramalingam, Sankarakumar wrote:
> > Hi I have my standby (streaming replication) down due to missing wal
> files.
> > You would see the same error in the logs stating "cannot find the wal
> file
> > ..." What
On Tuesday 21 June 2016 19:34:18 Ramalingam, Sankarakumar wrote:
> Hi I have my standby (streaming replication) down due to missing wal files.
> You would see the same error in the logs stating "cannot find the wal file
> ..." What is the best way to get it going so that when we switch between
> st
Hi I have my standby (streaming replication) down due to missing wal files. You
would see the same error in the logs stating "cannot find the wal file ..."
What is the best way to get it going so that when we switch between standby and
primary once in a while they are in sync?
Currently I am wor
