Re: [HACKERS] pg_upgrade may be mortally wounded

Поиск
Список
Период
Сортировка
От Bruce Momjian
Тема Re: [HACKERS] pg_upgrade may be mortally wounded
Дата
Msg-id 199909281609.MAA20393@candle.pha.pa.us
обсуждение исходный текст
Ответ на Re: [HACKERS] pg_upgrade may be mortally wounded  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
> Bruce Momjian <maillist@candle.pha.pa.us> writes:
> > Tom, did we address this.  I forgot.
>
> No, it's still an open issue as far as I'm concerned.  I was hoping to
> hear something from Vadim about how pg_upgrade could work safely under
> MVCC...
>

I don't think there is going to be any way to fix the incorrect
postmaster buffers without restarting the postmaster, so I have added
this to the bottom of pg_upgrade:

    echo "You must stop/start the postmaster before doing anything else."

and have re-organized the instructions to tell them to stop/start the
postmaster right after running pg_upgrade.

As it is, 6.5.* upgrades can not use it, and 6.6 can not use it either
because base structures will change.  It does allow 6.5 people moving to
other 6.5 releases to use initdb to get new features.

Let's close this item.

--
  Bruce Momjian                        |  http://www.op.net/~candle
  maillist@candle.pha.pa.us            |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026


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

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: [HACKERS] DROP TABLE inside transaction block
Следующее
От: "John Ridout"
Дата:
Сообщение: MS Access upsizing