On 3/5/19 9:16 PM, Andreas Kretschmer wrote:
Am 06.03.19 um 00:34 schrieb Julie Nishimura:
Hello there,
Is it possible for a test app to connect to the standby dB of an
active-Standby dB pair?
that's possible, but ...
While both continue to be connected and replicating? What if it’s
needed to write tmp tables that are later dropped?
... that's not. Not with streaming replication, but ...
Can it be done in hot standby scenario on standby? Version is 9.6.2
... it would be possible with logical replication (trigger based
solutions like slony or lindiste or logical replication using pglogical
from us, 2ndQ).
https://www.2ndquadrant.com/en/resources/pglogical/
You can also use BDR2 with PG9.6, but this is only available for our
customers.
Out of curiosity how did:
https://www.postgresql.org/message-id/20150831193033.GL2912%40alvherre.pgsql
https://www.postgresql.org/message-id/CAH+GA0qO0q9NJhKxaoo8CV-QR9Cuw6LtDGDb33pq16rU88F_dA@xxxxxxxxxxxxxx
get to?:
https://www.2ndquadrant.com/en/resources/postgres-bdr-2ndquadrant/
Regards, Andreas
--
Adrian Klaver
adrian.klaver@xxxxxxxxxxx
