From: | Edson Richter <edsonrichter(at)hotmail(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org, Madovsky <infos(at)madovsky(dot)org> |
Subject: | Re: Replication with 9.4 |
Date: | 2015-10-03 12:46:47 |
Message-ID: | COL402-EAS238E3E7C13F903A137D3EEECF4A0@phx.gbl |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
---- Madovsky escreveu ----
> 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
Sorry for my ignorance, but can you start a "transaction update" over a read only connection?
Edson
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(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
From | Date | Subject | |
---|---|---|---|
Next Message | Paolo De Michele | 2015-10-03 12:50:18 | Re: postgresql doesn't start |
Previous Message | Steve Petrie, P.Eng. | 2015-10-03 12:35:26 | *** CORRECTION -- PLEASE IGNORE *** BEGIN, END & ROLLBACK commands -- do they produce a SQLSTATE value? |