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
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_filenameand 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 по дате отправления: