Re: write on standby

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@mail.gmail.com

get to?:

https://www.2ndquadrant.com/en/resources/postgres-bdr-2ndquadrant/

> 
> 
> Regards, Andreas
> 


-- 
Adrian Klaver
adrian.klaver@aklaver.com