HotSync Replicate doubt?

From: Periko Support <pheriko(dot)support(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: HotSync Replicate doubt?
Date: 2017-03-30 16:39:40
Message-ID: CAK2yrTa2Sd9mrpeGPub5kshHvf_huE1uVw49L4G8B8greQvO8A@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi guys.

I had some doubt about PSQL internal replication mechanics(Streaming).

If I setup a Master-Slave Hot StandBy.

The slave is on a Read-Only stage, but we can query the server.

If a user create a table in the database:

CREATE DATABASE mynewdb;
CREATE TABLE mytbale-name + fields.

Or if changes a table with new fields or remove fields.

Does the replication will send this commands to the SLAVE without user
intervention?

I run bucardo for replication, but this feature doesn't work, we need
to manually do it on the
SLAVE and some other steps to have both DB sync.

We already know how to do it, bucardo works.

Just wondering if PSQL can handle this automatically?

Thanks.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Bill Moran 2017-03-30 16:48:46 Re: HotSync Replicate doubt?
Previous Message Moreno Andreo 2017-03-30 16:24:08 Re: PostgreSQL and Kubernetes