WAL receive process dies

From: Patrick Krecker <patrick(at)judicata(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: WAL receive process dies
Date: 2014-08-28 01:39:54
Message-ID: CAK2mJFNmZ1UoSLNT9xokqHBSuamA45NEC0cJ3nJ3BuEKub8-XA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

We have a periodic network connectivity issue (unrelated to Postgres) that
is causing the replication to fail.

We are running Postgres 9.3 using streaming replication. We also have WAL
archives available to be replayed with restore_command. Typically when I
bring up a slave it copies over WAL archives for a while before connecting
via streaming replication.

When I notice the machine is behind in replication, I also notice that the
WAL receiver process has died. There didn't seem to be any information in
the logs about it. The solution thus far has been to restart Postgres. I
have two questions:

1. It seems that Postgres does not fall back to copying WAL archives with
its restore_command. I just want to confirm that this is what Postgres is
supposed to do when its connection via streaming replication times out.
2. Is it possible to restart replication after the WAL receiver process has
died without restarting Postgres?

Thanks!
Patrick

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Yogesh. Sharma 2014-08-28 03:22:12 Help related to Postgresql for RHEL 6.5
Previous Message Jerry Sievers 2014-08-28 00:34:08 Re: Atomicity of INSERT INTO ... SELECT ... WHERE NOT EXISTS ...