Re: Converting non-null unique idx to pkey - Mailing list pgsql-general

From Kristo Kaiv
Subject Re: Converting non-null unique idx to pkey
Date
Msg-id 43ECF1D4-307E-4471-A240-A35B35CEEE00@skype.net
Whole thread Raw
In response to Re: Converting non-null unique idx to pkey  (Michael Glaesemann <grzm@seespotcode.net>)
List pgsql-general

On 23.08.2007, at 16:10, Michael Glaesemann wrote:


On Aug 23, 2007, at 7:44 , Kristo Kaiv wrote:


On 23.08.2007, at 11:23, Alban Hertroys wrote:

Since you're setting up replication to another database, you might as
well try replicating to a newer release and swap them around once it's
done. I've seen that method of upgrading mentioned on this list a few times.
Don't try this. Belive me you don't want to do it. We have had our fun with this 1.5 y ago

Care to share? Were you using Slony? AIUI, one of the motivations for Slony was to be able to do exactly that, so I'm sure there's interest in what didn't go as expected.
I think slony didn't have any problems with it. Something broke internally and we got rid of this by switching over (via Slony) to another server.

Kristo Kaiv
http://kaiv.wordpress.com (PostgreSQL blog)


pgsql-general by date:

Previous
From: "Albe Laurenz"
Date:
Subject: Re: pgsql functions: get column headers; optional arguments
Next
From: "Albe Laurenz"
Date:
Subject: Re: Undetected corruption of table files