| From: | Azimuddin Mohammed <azimeiu(at)gmail(dot)com> |
|---|---|
| To: | Rakesh Kumar <rakeshkumar464(at)aol(dot)com> |
| Cc: | pgsql-admin(at)postgresql(dot)org, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Sync replication |
| Date: | 2018-01-26 01:06:26 |
| Message-ID: | CAKUuFd5GCiJip8q8QOMQL0bZUBDbGnXTNJVxoLzhKe0+nwZo_w@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin pgsql-general |
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" <rakeshkumar464(at)aol(dot)com> wrote:
>
> >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 will wait for slave to come back up. PG"s replication is not the
> same as SQLServer/DB2/Oracle
> where they allow master to continue operating while the slave is down.
> useful during scheduled maintenance.
>
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Rakesh Kumar | 2018-01-26 01:09:57 | Re: Sync replication |
| Previous Message | Jorge Daniel | 2018-01-25 20:58:44 | Re: OOM Killing on Docker while ANALYZE running |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Rakesh Kumar | 2018-01-26 01:09:57 | Re: Sync replication |
| Previous Message | Adrian Klaver | 2018-01-25 23:41:26 | Re: A little RULE help? |