Re: sync structures

----- "John" <jfabiani(at)yolo(dot)com> wrote:

> On Monday 28 September 2009 09:06:25 am Filip Rembiałkowski wrote:
> > 2009/9/28 John <jfabiani(at)yolo(dot)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
>
> 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(at)comcast(dot)net