| From: | Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org> |
|---|---|
| To: | Ivan Voras <ivoras(at)gmail(dot)com> |
| Cc: | "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Writing on replicas? |
| Date: | 2017-09-19 11:48:29 |
| Message-ID: | 20170919114829.m2qr4e4cgrx6rusk@alvherre.pgsql |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Ivan Voras wrote:
> The reporting code is *almost* read-only, with the major exception being
> that it creates temp tables for intermediate results. The main tables are
> not written to, just the temp tables.
>
> Some time ago when I've asked what to do in this situation, the answer was
> that maybe a future version could allow this setup to work. So, I'm asking
> again: was something changed in 10.0 which would allow it?
No, but you could use logical replication (with either pglogical or
pg10's more limited native features).
--
Álvaro Herrera https://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Yason TR | 2017-09-19 13:34:28 | |
| Previous Message | Ivan Voras | 2017-09-19 11:40:36 | Writing on replicas? |