Search Postgresql Archives

Replication with 9.4

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

 



Hi,

I would like to fix a issue I'm facing of with the version 9.4 streaming replication. is it possible to set on the fly the synchronous commit on the master (or standby?) which only sync commit the hot standby node used by the client who has a read only sql session on?
example:
node1 node2 node3 are hot standby with replication slots (physical) on master 1
node1 has the priority 1 since it's first on the names list
now a client open a ready only session on node3 and start a transaction update but within this transaction a sql select is done on the hot standby from the updated table

thanks

Franck


--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general



[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