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