Search Postgresql Archives

Re: Sync replication

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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@xxxxxxx> 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.


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux