Re: [GENERAL] Updating a production database schema from dev server

2008-01-04 Thread mljv
Hi, try using liquibase. http://www.liquibase.org/ . It works very well. kind regards, Janning Am Dienstag, 16. Oktober 2007 18:38 schrieb Stanislav Raskin: > Hello everybody, > > > > I am currently running two PostgreSQL servers on two different machines. > One of them I use for development and

Re: [GENERAL] Updating a production database schema from dev server

2007-10-16 Thread Stanislav Raskin
endet: Dienstag, 16. Oktober 2007 19:51 An: Stanislav Raskin Cc: pgsql-general@postgresql.org Betreff: Re: [GENERAL] Updating a production database schema from dev server On 10/16/07, Stanislav Raskin <[EMAIL PROTECTED]> wrote: > > Hello everybody, > > I am currently running tw

Re: [GENERAL] Updating a production database schema from dev server

2007-10-16 Thread Michael Crozier
Stanislav Raskin wrote: I figure there must be a better way to do so. Is there some kind of software, which compares two database schemas (preferably two sql dumps), and generates a script for applying differences to one of them? What would be the best practice for applying such updates witho

Re: [GENERAL] Updating a production database schema from dev server

2007-10-16 Thread Richard Huxton
Stanislav Raskin wrote: I figure there must be a better way to do so. Is there some kind of software, which compares two database schemas (preferably two sql dumps), and generates a script for applying differences to one of them? What would be the best practice for applying such updates witho

Re: [GENERAL] Updating a production database schema from dev server

2007-10-16 Thread Scott Marlowe
On 10/16/07, Stanislav Raskin <[EMAIL PROTECTED]> wrote: > > Hello everybody, > > I am currently running two PostgreSQL servers on two different machines. One > of them I use for development and the other one as the "real" production > server for my applications. > > While developing new versions o