| From: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
|---|---|
| To: | Julie Nishimura <juliezain(at)hotmail(dot)com>, "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: write on standby |
| Date: | 2019-03-05 23:49:10 |
| Message-ID: | 24a705d3-4fc0-c771-589c-895915946cdf@aklaver.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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(dot)klaver(at)aklaver(dot)com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Matthew Pounsett | 2019-03-05 23:52:36 | Re: [External] LIMIT not showing all results |
| Previous Message | Adrian Klaver | 2019-03-05 23:39:25 | Re: [External] LIMIT not showing all results |