On Thu, 30 Mar 2017 09:39:40 -0700 Periko Support <pheriko.support@xxxxxxxxx> 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@xxxxxxxxxxxxxxxxx> -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
