From: | Scott Ribe <scott_ribe(at)elevated-dev(dot)com> |
---|---|
To: | czezz <czezz(at)o2(dot)pl> |
Cc: | "pgsql-admin(at)lists(dot)postgresql(dot)org" <pgsql-admin(at)lists(dot)postgresql(dot)org> |
Subject: | Re: schema update? |
Date: | 2018-06-15 11:40:57 |
Message-ID: | 6D883DDD-933E-45A7-B3F4-95CFD7EA8C13@elevated-dev.com |
Views: | Whole Thread | Raw Message | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
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(at)elevated-dev(dot)com
https://www.linkedin.com/in/scottribe/
> On Jun 15, 2018, at 4:06 AM, czezz <czezz(at)o2(dot)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?
>
From | Date | Subject | |
---|---|---|---|
Next Message | Debraj Manna | 2018-06-15 16:05:18 | How to get current timeline of host in postgres 10.4? |
Previous Message | Pavan Teja | 2018-06-15 10:21:58 | Re: schema update? |