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 <[email protected]> wrote: > We're having an issue with our warm standby server. About 9:30 last night, it > stopped applying changes it received in WAL files that are shipped over to it > as they are created. It is still reading WAL files as they delivered, as the > startup_log.txt shows, but the changes in the primary database aren't > actually being made to the standby, and haven't been since 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 base backup, and we'd like > to figure out what is happening so we can prevent it in the future. > > Thanks! -- Sent via pgsql-general mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
