Re: "duplicate key value": version 8.4 vs 8.1

Поиск
Список
Период
Сортировка
От Frank Bax
Тема Re: "duplicate key value": version 8.4 vs 8.1
Дата
Msg-id 4CC17471.8050801@sympatico.ca
обсуждение исходный текст
Ответ на Re: "duplicate key value": version 8.4 vs 8.1  (mountain oaf <mountainoaf@gmail.com>)
Список pgsql-novice
mountain oaf wrote:
>> You may want to try the latest version of 8.1, 8.1.22 or 20 bugfix
>> releases more current. As has been oft repeated here, they do not
>> release them for fun. They fix real and critical bugs.
>
> Thanks for the thought. Unfortunately this is not an option as it is
> running a client's system at a remote site.


Upgrades do not require on-site access.

Every production system should have a backup; so I keep a second server
on standby.  For upgrades; I upgrade the backup system; test my apps on
the upgraded system; then with only a few minutes downtime I resync the
data and make backup hardware productions server.  Then I upgrade the
original system; test it and migrate back again.

This process tests the disaster recovery process with every upgrade.

This process only requires on-site visit when upgrading the OS; never
packages like Postgresql.

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

Предыдущее
От: Vibhor Kumar
Дата:
Сообщение: Re: Incremental Backup
Следующее
От: Chris Campbell
Дата:
Сообщение: Changing Field Ordinal Position