WAL Replication Working but Not Working

From: Joseph Marlin <jmarlin(at)saucontech(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: WAL Replication Working but Not Working
Date: 2013-08-21 14:08:23
Message-ID: 1165485744.102989078.1377094103498.JavaMail.root@saucontech.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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!

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2013-08-21 14:08:58 Re: Locale Issue
Previous Message Tom Lane 2013-08-21 14:03:48 Re: Bug in psql (\dd query)