From: | Julie Nishimura <juliezain(at)hotmail(dot)com> |
---|---|
To: | Andreas Kretschmer <andreas(at)a-kretschmer(dot)de>, "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org> |
Subject: | Re: write on standby |
Date: | 2019-03-06 05:26:45 |
Message-ID: | BYAPR08MB50147D31209B884BE7396D99AC730@BYAPR08MB5014.namprd08.prod.outlook.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Thank you. Are you going to have any presentations on Postgresql conference in NYC soon?
________________________________
From: Andreas Kretschmer <andreas(at)a-kretschmer(dot)de>
Sent: Tuesday, March 5, 2019 9:16 PM
To: pgsql-general(at)lists(dot)postgresql(dot)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>
From | Date | Subject | |
---|---|---|---|
Next Message | Andreas Kretschmer | 2019-03-06 05:32:47 | Re: write on standby |
Previous Message | Andreas Kretschmer | 2019-03-06 05:20:43 | Re: Non-pausing table scan on 9.6 replica? |