Re: How to update from 8.1 to 8.2 ?

Поиск
Список
Период
Сортировка
От Chris Hoover
Тема Re: How to update from 8.1 to 8.2 ?
Дата
Msg-id 1d219a6f0709201106n24c000a7p9006f5b7257f2d69@mail.gmail.com
обсуждение исходный текст
Ответ на Re: How to update from 8.1 to 8.2 ?  (Carol Walter <walterc@indiana.edu>)
Ответы Re: How to update from 8.1 to 8.2 ?  (Carol Walter <walterc@indiana.edu>)
Список pgsql-admin


On 9/20/07, Carol Walter <walterc@indiana.edu> wrote:
We just did this.  I did a pg_dumpall using 8.1.  Then we fired up
8.2 while 8.1 was still running.  Uploaded the data to 8.2.  Then
shut 8.1 down.  This allowed us to have the database unavailable for
a very short time.

Carol


Carol,

If this is truely what you did, you are a very lucky person.  You are always supposed to dump the old database using the new versions pg_dump/pg_dumpall.  That way, pg_dump/pg_dumpall can set up the data for any changes made by the newer version.

Just an fyi for those following this thread.

HTH,

chris


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

Предыдущее
От: "Kevin Grittner"
Дата:
Сообщение: Re: Schedules Running Problem
Следующее
От: "Chris Hoover"
Дата:
Сообщение: Re: Moving database install to new SAN