Re: schema update?

Поиск
Список
Период
Сортировка
От Pavan Teja
Тема Re: schema update?
Дата
Msg-id CACh9nsaWwA5-_9nQ8=iiENPBPy_8CLD27cvK_yXNOjjvbV0iYw@mail.gmail.com
обсуждение исходный текст
Ответ на schema update?  (czezz <czezz@o2.pl>)
Список 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@o2.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

В списке pgsql-admin по дате отправления:

Предыдущее
От: czezz
Дата:
Сообщение: schema update?
Следующее
От: Scott Ribe
Дата:
Сообщение: Re: schema update?