| From: | Andreas Kretschmer <andreas(at)a-kretschmer(dot)de> |
|---|---|
| To: | pgsql-general(at)lists(dot)postgresql(dot)org |
| Subject: | Re: write on standby |
| Date: | 2019-03-06 05:16:27 |
| Message-ID: | ea2e18e5-987d-54eb-81ab-66a65c7ee16c@a-kretschmer.de |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Andreas Kretschmer | 2019-03-06 05:20:43 | Re: Non-pausing table scan on 9.6 replica? |
| Previous Message | Adrian Klaver | 2019-03-06 05:09:11 | Re: Connection Drop from PostgreSQL Database Server |