Re: write on standby - Mailing list pgsql-general

From Andreas Kretschmer
Subject Re: write on standby
Date
Msg-id 616D8801-736F-472A-9B99-5967E39C8E85@a-kretschmer.de
Whole thread Raw
In response to Re: write on standby  (Julie Nishimura <juliezain@hotmail.com>)
List pgsql-general
On 6 March 2019 06:26:45 CET, Julie Nishimura <juliezain@hotmail.com> wrote:
>Thank you. Are you going to have any presentations on Postgresql
>conference in NYC soon?
>
>________________________________
>From: Andreas Kretschmer <andreas@a-kretschmer.de>
>Sent: Tuesday, March 5, 2019 9:16 PM
>To: pgsql-general@lists.postgresql.org
>Subject: Re: write on standby
>
>
>
>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.
>
>
>Regards, Andreas
>
>--
>2ndQuadrant - The PostgreSQL Support Company.
>www.2ndQuadrant.com<http://www.2ndQuadrant.com>

Hi,

I think so, if you want i can organize a contact with someone from our company.


Andreas (from germany)
--
2ndQuadrant - The PostgreSQL Support Company


pgsql-general by date:

Previous
From: Julie Nishimura
Date:
Subject: Re: write on standby
Next
From: Mark Fletcher
Date:
Subject: Re: Non-pausing table scan on 9.6 replica?