From: Frank Alberto Rodriguez <franknigth@gmail.com>
To: pgsql-admin@lists.postgresql.org
Subject: Re: Materialize view in slave server
Date: Mon, 01 Apr 2019 09:32:03 -0600
Message-ID: <1870914.oP4ivU0TkW@frodriguez-hp-notebook> (raw)
In-Reply-To: <CAEXKJoU2HMR_6J8WD5jhsn32a-TRnP6spc00=v5hL0ec5gbF1Q@mail.gmail.com>
References: <CAEXKJoU2HMR_6J8WD5jhsn32a-TRnP6spc00=v5hL0ec5gbF1Q@mail.gmail.com>
Hello. If you planned to writes over materialized views, you should use the
primary server, because the slave must be to read only.
If you want to avoid writes in the slave, use normal views instead, otherwise
ensure the writes over a materialized view occur in a primary node only, but
reading it on slave node would not be a problem.
Regards
On lunes, 1 de abril de 2019 09:02:13 CST Mahmoud Moharam wrote:
> Hello All ,
> hope every thing is well with you all ,
> I planned to run stream replication (primary / slave) on my environment ,
> and want to make writes on primary and reads from slave , so the question
> is :- I have Materialize view running on primary , what is the best choose
> to run Materialize view on primary or on slave ?
>
> thanks all
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: franknigth@gmail.com, pgsql-admin@lists.postgresql.org
Subject: Re: Materialize view in slave server
In-Reply-To: <1870914.oP4ivU0TkW@frodriguez-hp-notebook>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox