Re: Sync replication

2018-01-25 Thread Stephen Frost
Greetings Michael, * Michael Paquier (michael.paqu...@gmail.com) wrote: > On Thu, Jan 25, 2018 at 08:21:43PM -0500, Stephen Frost wrote: > > That's correct, which is why it's encouraged to have multiple replicas > > configured when using synchronous replication. In v10, it's possible to > > speci

Re: Sync replication

2018-01-25 Thread Michael Paquier
On Thu, Jan 25, 2018 at 08:21:43PM -0500, Stephen Frost wrote: > That's correct, which is why it's encouraged to have multiple replicas > configured when using synchronous replication. In v10, it's possible to > specify how many synchronous replicas are required to have acknowledged > a given tran

Re: Sync replication

2018-01-25 Thread Stephen Frost
Greetings, On our mailing lists, we prefer that replies be in-line and ask that users not top-post. Please see my response, in-line, below. * Azimuddin Mohammed (azim...@gmail.com) wrote: > So untill my slave comes up master does not commit any transaction which > means technically my db is non

Re: Sync replication

2018-01-25 Thread Rakesh Kumar
correct. -Original Message- From: Azimuddin Mohammed To: Rakesh Kumar Cc: pgsql-admin ; pgsql-general Sent: Thu, Jan 25, 2018 8:06 pm Subject: Re: Sync replication So untill my slave comes up master does not commit any transaction which means technically my db is non operative

Re: Sync replication

2018-01-25 Thread Azimuddin Mohammed
So untill my slave comes up master does not commit any transaction which means technically my db is non operative? On Jan 25, 2018 12:23 PM, "Rakesh Kumar" wrote: > > >I have a question regarding synchronus replication. > >If i have a master and standby server will sync replication setup..when >

Re: Sync replication

2018-01-25 Thread Rakesh Kumar
>I have a question regarding synchronus replication. >If i have a master and standby server will sync replication setup..when my >slave dies and master is still active. Will the transaction completes, or >>master will wait for slave to commit the transaction and then commits its. ? Master