write on standby
Hello there,
Is it possible for a test app to connect to the standby dB of an active-Standby dB pair? While both continue to be connected and replicating? What if it’s needed to write tmp tables that are later dropped? Can it be done in hot standby scenario on standby? Version is 9.6.2
Thanks
On 3/5/19 3:34 PM, Julie Nishimura wrote:
Hello there,
Is it possible for a test app to connect to the standby dB of an
active-Standby dB pair? �While both continue to be connected and
replicating? What if it�s needed to write tmp tables that are later
dropped? Can it be done in hot standby scenario on standby? Version is 9.6.2
No:
https://www.postgresql.org/docs/9.6/hot-standby.html
26.5.1. User's Overview
In particular:
"Data Definition Language (DDL) - CREATE, DROP, ALTER, COMMENT. This
restriction applies even to temporary tables, because carrying out these
operations would require updating the system catalog tables."
Thanks
--
Adrian Klaver
adrian.klaver@aklaver.com
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
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>
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 standbyAm 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
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:
/messages/by-id/20150831193033.GL2912@alvherre.pgsql
/messages/by-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