[GENERAL] Schema Upgrade Howto

2008-10-30 Thread Thomas Guettler
Hi, is there a schema upgrade howto? I could not find much with google. There is a running DB and a development DB. The development DB has some tables, columns and indexes added. What is the preferred way to upgrade? I see these solutions: - pg_dump production DB. Install schema only from dev

Re: [GENERAL] Schema Upgrade Howto

2008-10-30 Thread David Fetter
On Thu, Oct 30, 2008 at 10:54:46AM +0100, Thomas Guettler wrote: Hi, is there a schema upgrade howto? I could not find much with google. There is a running DB and a development DB. The development DB has some tables, columns and indexes added. The only sure way to track such changes is by

Re: [GENERAL] Schema Upgrade Howto

2008-10-30 Thread Thomas Guettler
Hi, I found a way to do it. One problem remains: The order of the columns can't be changed. Any change to make postgres support this in the future? My way: pg_dump -s prod | strip-schema-dump.py - prod.schema pg_dump -s devel | strip-schema-dump.py - devel.schema strip-schema-dump.py

Re: [GENERAL] Schema Upgrade Howto

2008-10-30 Thread David Fetter
On Thu, Oct 30, 2008 at 02:37:43PM +0100, Thomas Guettler wrote: Hi, I found a way to do it. It's the wrong way. Trust me on this. One problem remains: The order of the columns can't be changed. Any change to make postgres support this in the future? It's been proposed several times :)

Re: [GENERAL] Schema Upgrade Howto

2008-10-30 Thread Berend Tober
Thomas Guettler wrote: Hi, is there a schema upgrade howto? I could not find much with google. There is a running DB and a development DB. The development DB has some tables, columns and indexes added. What is the preferred way to upgrade? I see these solutions: - pg_dump production DB.