Re: minimizing downtime when upgrading

Поиск
Список
Период
Сортировка
От Kenneth Downs
Тема Re: minimizing downtime when upgrading
Дата
Msg-id 44928ABB.9070905@secdat.com
обсуждение исходный текст
Ответ на minimizing downtime when upgrading  (snacktime <snacktime@gmail.com>)
Ответы Re: minimizing downtime when upgrading
Список pgsql-general
snacktime wrote:

> Anyone have any tips for minimizing downtime when upgrading?  So far
> we have done upgrades during scheduled downtimes.  Now we are getting
> to the point where the time required for a standard dump/restore is
> just too long.  What have others done when downtime is critical?  The
> only solution we have been able to come up with is to migrate the data
> on a per user basis to a new database server.  Each user is a
> merchant, and the data in the database is order data.  Migrating one
> merchant at a time will keep the downtime per merchant limited to just
> the time it takes to migrate the data for that merchant, which is
> acceptable.


AFAIK it has always been the case that you should expect to have to dump
out your databases and reload them for version upgrades.

Is anybody over at the dev team considering what an onerous burden this
is?  Is anyone considering doing away with it?



Вложения

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

Предыдущее
От: "Dave Page"
Дата:
Сообщение: Re: postgres password
Следующее
От: Douglas McNaught
Дата:
Сообщение: Re: VACUUMing sometimes increasing database size /