Materialized views in PGSQL 9.3 with replication on.

From: Vikas Sharma <shavikas(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Materialized views in PGSQL 9.3 with replication on.
Date: 2018-01-08 15:46:40
Message-ID: CAN6gwKxDgrKs8LwT7iytfiZdP=khqU4bR531wrqTgM-qierG6w@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi There,

We are using postgresql 9.3 with streaming replication to 3 standby nodes.
I have a question about Materialized views.
When the refresh for MV runs on Master how it's data is replicated to
Stanby nodes?
Does the refresh command runs on the standby nodes as well as it runs on
Master and when the new data visible in standbys for the MV?
I think it's the changed data replicated from Master to Standby's so
changed data is streamed from master to Standbys.

Regards
Vikas Sharma

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2018-01-08 16:32:39 Re: Pg Upgrade failing as it is not able to start and stop server properly
Previous Message Guru Prashanth Thanakodi 2018-01-08 14:20:04 Re: Pg Upgrade failing as it is not able to start and stop server properly