Re: Postgres HA issue - Standby server does not start after Master compute host is shut down

2019-09-04 Thread Luca Ferrari
On Tue, Sep 3, 2019 at 6:08 PM Nagendra Bandi wrote: > Standby is built from the primary using pg_basebackup. i.e. Initial copy of > the primary database is taken with pg_basebackup command and then restarted > the server. This puzzles me: < 2019-09-01 15:43:56.440 UTC >LOG: trigger file foun

Re: Postgres HA issue - Standby server does not start after Master compute host is shut down

2019-09-04 Thread Jehan-Guillaume (ioguix) de Rorthais
On Tue, 3 Sep 2019 21:31:23 +0530 Nagendra Bandi wrote: > Hi Jehan, > Thanks for your quick response. > Standby is built from the primary using pg_basebackup. i.e. Initial copy of > the primary database is taken with pg_basebackup command pg_basebackup is supposed to make an non-exclusive backup

Re: Postgres HA issue - Standby server does not start after Master compute host is shut down

2019-09-03 Thread Nagendra Bandi
Hi Jehan, Thanks for your quick response. Standby is built from the primary using pg_basebackup. i.e. Initial copy of the primary database is taken with pg_basebackup command and then restarted the server. Regards, Nagendra On Tue, Sep 3, 2019 at 8:43 PM Jehan-Guillaume (ioguix) de Rorthais < iog.

Re: Postgres HA issue - Standby server does not start after Master compute host is shut down

2019-09-03 Thread Jehan-Guillaume (ioguix) de Rorthais
On Tue, 3 Sep 2019 20:27:37 +0530 Nagendra Bandi wrote: ... > *Problem Description :* > > PostgreSQL database is set up for High Availability and *asynchronous > streaming replication* with *hot standby* as described in > https://www.postgresql.org/docs/9.4/warm-standby.html#STREAMING-REPLICATION