Re: Converting non-null unique idx to pkey

Поиск
Список
Период
Сортировка
От Kristo Kaiv
Тема Re: Converting non-null unique idx to pkey
Дата
Msg-id 83179F8C-716C-448C-B4CD-85385F69C9A8@skype.net
обсуждение исходный текст
Ответ на Re: Converting non-null unique idx to pkey  (Alban Hertroys <alban@magproductions.nl>)
Ответы Re: Converting non-null unique idx to pkey
Список pgsql-general

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

Ed L. wrote:
On Tuesday 21 August 2007 1:45 pm, Scott Marlowe wrote:
If you have a large db in 7.4.6, you should do two things.

1: Update to 7.4.19 or whatever the latest flavor of 7.4 is,
right now.  There are a few known data eating bugs in 7.4.6.

Sounds like good advice from a strictly technical viewpoint.  
Unfortunately, in our particular real world, there are also 
political, financial, and resource constraints and impacts from 
downtime that at times outweigh the technical merits of 
upgrading 'right now'.

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

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


В списке pgsql-general по дате отправления:

Предыдущее
От: Andrew Kelly
Дата:
Сообщение: Re: reporting tools
Следующее
От: Richard Huxton
Дата:
Сообщение: Re: %TYPE