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