HotSync Replicate doubt?

On Thu, 30 Mar 2017 09:39:40 -0700
Periko Support <pheriko.support@gmail.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@potentialtech.com>

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

On 03/30/2017 09:39 AM, Periko Support 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?

Yes, with an exception:

https://www.postgresql.org/docs/9.6/static/warm-standby.html

26.2.1. Planning

"Keep in mind that if CREATE TABLESPACE is executed on the primary, any
new mount point needed for it must be created on the primary and all
standby servers before the command is executed"

Thanks.

--
Adrian Klaver
adrian.klaver@aklaver.com

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Good, them I must tested, thanks guys!!!

On Thu, Mar 30, 2017 at 9:49 AM, Adrian Klaver
<adrian.klaver@aklaver.com> wrote:

On 03/30/2017 09:39 AM, Periko Support 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?

Yes, with an exception:

https://www.postgresql.org/docs/9.6/static/warm-standby.html

26.2.1. Planning

"Keep in mind that if CREATE TABLESPACE is executed on the primary, any new
mount point needed for it must be created on the primary and all standby
servers before the command is executed"

Thanks.

--
Adrian Klaver
adrian.klaver@aklaver.com

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general