| From: | Kristo Kaiv <kristo(dot)kaiv(at)skype(dot)net> |
|---|---|
| To: | Michael Glaesemann <grzm(at)seespotcode(dot)net> |
| Cc: | Alban Hertroys <alban(at)magproductions(dot)nl>, "Ed L(dot)" <pgsql(at)bluepolka(dot)net>, Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>, Postgres-General <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Converting non-null unique idx to pkey |
| Date: | 2007-08-27 07:55:09 |
| Message-ID: | 43ECF1D4-307E-4471-A240-A35B35CEEE00@skype.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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)
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Albe Laurenz | 2007-08-27 08:06:38 | Re: Undetected corruption of table files |
| Previous Message | Kristo Kaiv | 2007-08-27 07:52:38 | Re: [GENERAL] table column vs. out param [1:0] |