Request a Demo
Home   >   mailing lists

Re: sync structures - Mailing list pgsql-general

From Filip Rembiałkowski
Subject Re: sync structures
Date
Msg-id 92869e660909280906m67a0dc0ap145f21eba692e307@mail.gmail.com
Whole thread Raw
In response to sync structures  (John <jfabiani@yolo.com>)
Responses Re: sync structures
List pgsql-general
Tree view


2009/9/28 John <jfabiani@yolo.com>
Hi,
I have a development DB and a production DB.  I need a way to sync the changes
I make to the stucture in the devel DB to the production DB.  I found pgdiff
but can't get it to work.  I would like a solution that would work on windows
and linux.   But I'll take either alone.

postgres 8.3
openSUSE 11.0
windows XP/vista

Thanks in advance for any help.


You could use standard text compare programs. They won't  write a patch for you. There's still some niche for live DBAs.

pg_dump -sOx dev_db_name > dev.schema
pg_dump -sOx prod_db_name > prod.schema
diff -u dev.schema prod.schema




--
Filip Rembiałkowski
JID,mailto:filip.rembialkowski@gmail.com
http://filip.rembialkowski.net/

pgsql-general by date:

Previous
From: Reid Thompson
Date:
Subject: computed values in plpgsql
Next
From: Maximilian Tyrtania
Date:
Subject: bytea question