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. Insta
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
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 remov
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
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 D
