Search Postgresql Archives

Re: sync structures

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux