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(dot)klaver(at)aklaver(dot)com