On Thu, Aug 15, 2013 at 11:07 AM, Andrew Berman <rexx...@gmail.com> wrote: > Hello, > > I'm having an issue where streaming replication just randomly stops working. > I haven't been able to find anything in the logs which point to an issue, > but the Postgres process shows a "waiting" status on the slave: > > postgres 5639 0.1 24.3 3428264 2970236 ? Ss Aug14 1:54 postgres: > startup process recovering 000000010000053D0000003F waiting
There is a recovery conflict which it is waiting to go away. In other words, you have a long-running (or long-idle) transaction on the slave which is blocking recovery. > max_standby_archive_delay = -1 > max_standby_streaming_delay = -1 ...and you are willing to wait forever. Cheers, Jeff -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
