On Monday 28 September 2009 09:31:30 am Adrian Klaver wrote: > ----- "John" <jfabiani@xxxxxxxx> wrote: > > On Monday 28 September 2009 09:06:25 am Filip Rembiałkowski wrote: > > > 2009/9/28 John <jfabiani@xxxxxxxx> > > > > > > > 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 > > > > Thanks that will help. After all this time I'm surprized that someone > > hasn't > > provide an easy way to get this done. It's has to be every developers > > > > problem. > > > > Johnf > > I have looked at but not tried pgmigrate: > http://code.google.com/p/pgmigrate/ > > It might do what you want. > > > Adrian Klaver > aklaver@xxxxxxxxxxx Thanks Adrian and looks like it's in python too which is a major plus. Johnf -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
