Thread: schema update?
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
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
Nothing built in. So, assuming streaming replication doesn't work for you because these systems have different data, youhave 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@elevated-dev.com https://www.linkedin.com/in/scottribe/ > On Jun 15, 2018, at 4:06 AM, czezz <czezz@o2.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? >