From: Scott Ribe <scott_ribe@elevated-dev.com>
To: czezz <czezz@o2.pl>
Cc: pgsql-admin@lists.postgresql.org <pgsql-admin@lists.postgresql.org>
Subject: Re: schema update?
Date: Fri, 15 Jun 2018 05:40:57 -0600
Message-ID: <6D883DDD-933E-45A7-B3F4-95CFD7EA8C13@elevated-dev.com> (raw)
In-Reply-To: <fcd6f839727c45638857b40cb0aee9a3@grupawp.pl>
References: <fcd6f839727c45638857b40cb0aee9a3@grupawp.pl>
Nothing built in. So, assuming streaming replication doesn't work for you because these systems have different data, you have two choices:
- track schema changes as any other source so you have the change DDL available
- use a 3rd-party tool
--
Scott Ribe
scott_ribe@elevated-dev.com
https://www.linkedin.com/in/scottribe/> On Jun 15, 2018, at 4:06 AM, czezz <czezz@o2.pl> wrote:
>
> However, is there a way to apply only differences of schema on Machine2 ?
> In other words to update schema with changes from Machine1?
>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: scott_ribe@elevated-dev.com, czezz@o2.pl, pgsql-admin@lists.postgresql.org
Subject: Re: schema update?
In-Reply-To: <6D883DDD-933E-45A7-B3F4-95CFD7EA8C13@elevated-dev.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox