Thread: WAL Replication Working but Not Working

WAL Replication Working but Not Working

From
Joseph Marlin
Date:
We're having an issue with our warm standby server. About 9:30 last night, it stopped applying changes it received in
WALfiles that are shipped over to it as they are created. It is still reading WAL files as they delivered, as the
startup_log.txtshows, but the changes in the primary database aren't actually being made to the standby, and haven't
beensince last night. 

Is there any way we can figure out what is going on here? We'd like to recover somehow without having to restore from a
basebackup, and we'd like to figure out what is happening so we can prevent it in the future. 

Thanks!


Re: WAL Replication Working but Not Working

From
Lonni J Friedman
Date:
The first thing to do is look at your server logs around the time when
it stopped working.

On Wed, Aug 21, 2013 at 7:08 AM, Joseph Marlin <jmarlin@saucontech.com> wrote:
> We're having an issue with our warm standby server. About 9:30 last night, it stopped applying changes it received in
WALfiles that are shipped over to it as they are created. It is still reading WAL files as they delivered, as the
startup_log.txtshows, but the changes in the primary database aren't actually being made to the standby, and haven't
beensince last night. 
>
> Is there any way we can figure out what is going on here? We'd like to recover somehow without having to restore from
abase backup, and we'd like to figure out what is happening so we can prevent it in the future. 
>
> Thanks!