Search Postgresql Archives

Re: Converting non-null unique idx to pkey

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

 




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)



[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