[GENERAL] standby database crash

2017-08-03 Thread Murtuza Zabuawala
++ Forwarding to pgsql-general group. -- Forwarded message -- From: Seong Son (US) Date: Thu, Aug 3, 2017 at 12:48 AM Subject: standby database crash To: "pgadmin-supp...@lists.postgresql.org" < pgadmin-supp...@lists.postgresql.org> Hello, I’ve posted

Re: [GENERAL] standby database crash

2017-08-01 Thread Michael Paquier
On Mon, Jul 31, 2017 at 11:15 PM, Seong Son (US) wrote: > So my questions are, could an old WAL segment being resent through the > network cause crash like this? Shouldn’t Postgresql be able to handle out > of order WAL segments instead of just crashing? When the

[GENERAL] standby database crash

2017-07-31 Thread Seong Son (US)
I have a client who has streaming replication setup with the primary in one city and standby in another city both identical servers with Postgresql 9.6 on Windows Server 2012. They have some network issues, which is causing the connection from the primary to standby to drop sometimes. And