From: | Pavan Teja <pavan(dot)postgresdba(at)gmail(dot)com> |
---|---|
To: | czezz <czezz(at)o2(dot)pl> |
Cc: | pgsql-admin(at)lists(dot)postgresql(dot)org |
Subject: | Re: schema update? |
Date: | 2018-06-15 10:21:58 |
Message-ID: | CACh9nsaWwA5-_9nQ8=iiENPBPy_8CLD27cvK_yXNOjjvbV0iYw@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Hi Czezz,
I think you can't. What you could do, is setting up WAL archiving to make
incremental backups:
http://www.postgresql.org/docs/current/static/continuous-archiving.html#BACKUP-ARCHIVING-WAL
Instead you can set streaming replication between both machines
On Fri, Jun 15, 2018, 3:37 PM czezz <czezz(at)o2(dot)pl> wrote:
> Hi everyone,
>
> By executing following I copy schema from Machine1:
> pg_dump -s <database name> > pg_dump_text_filename
>
> and then at the psql prompt I can restore it on the Machine2:
> \i <pg_dump_text_file_path>
>
>
> That works good.
> However, is there a way to apply only differences of schema on Machine2 ?
> In other words to update schema with changes from Machine1?
>
> Best regards,
> czezz
>
From | Date | Subject | |
---|---|---|---|
Next Message | Scott Ribe | 2018-06-15 11:40:57 | Re: schema update? |
Previous Message | czezz | 2018-06-15 10:06:52 | schema update? |