Re: Promote replica before being able to accept connections

2019-02-11 Thread Michael Paquier
On Mon, Feb 11, 2019 at 06:59:27AM -0800, Martín Fernández wrote: > That makes sense! > > Thanks for the quick reply Note that PostgreSQL 9.4 has introduced a new parameter in recovery.conf that allows recovery to finish exactly when a consistent state has been reached: recovery_target = 'immedia

Re: Promote replica before being able to accept connections

2019-02-11 Thread Martín Fernández
Laurenz, That makes sense!  Thanks for the quick reply Best, Martín On Mon, Feb 11th, 2019 at 7:55 AM, Laurenz Albe wrote: > > > > Martín Fernández wrote: > > We have a 9.2 pg cluster and we are in the process of rebuilding a > master database in our staging environment. > > In order to

Re: Promote replica before being able to accept connections

2019-02-11 Thread Laurenz Albe
Martín Fernández wrote: > We have a 9.2 pg cluster and we are in the process of rebuilding a master > database in our staging environment. > In order to achieve the latter goal, we are restoring our staging database > using pg_basebackup against one > of our production replicas. > > pg_baseback

Promote replica before being able to accept connections

2019-02-10 Thread Martín Fernández
Hello Everyone! We have a 9.2 pg cluster and we are in the process of rebuilding a master database in our staging environment. In order to achieve the latter goal, we are restoring our staging database using pg_basebackup against one of our production replicas. pg_basebackup has completed and the