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@xxxxxxxxxxx
