Re: WAL Replication Working but Not Working - Mailing list pgsql-general

From Lonni J Friedman
Subject Re: WAL Replication Working but Not Working
Date
Msg-id CAP=oouEESE7dV16pCA=j9NhhnnJz05VefnbFQ+wqd1kF9VVm+g@mail.gmail.com
Whole thread Raw
In response to WAL Replication Working but Not Working  (Joseph Marlin <jmarlin@saucontech.com>)
List pgsql-general
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!


pgsql-general by date:

Previous
From: Joseph Marlin
Date:
Subject: WAL Replication Working but Not Working
Next
From: "carlosinfl ."
Date:
Subject: PostgreSQL 9.2 Logging