Re: schema update?

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

In response to

Browse pgsql-admin by date

  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?