Re: HotSync Replicate doubt?

On Thu, 30 Mar 2017 09:39:40 -0700
Periko Support <pheriko(dot)support(at)gmail(dot)com> wrote:

> 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?

Postgres' built-in streaming replication _does_ replicate this automatically.

--
Bill Moran <wmoran(at)potentialtech(dot)com>