Re: [HACKERS] pg_upgrade may be mortally wounded - Mailing list pgsql-hackers

From Bruce Momjian
Subject Re: [HACKERS] pg_upgrade may be mortally wounded
Date
Msg-id 199909281609.MAA20393@candle.pha.pa.us
Whole thread Raw
In response to Re: [HACKERS] pg_upgrade may be mortally wounded  (Tom Lane <tgl@sss.pgh.pa.us>)
List 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 by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: [HACKERS] DROP TABLE inside transaction block
Next
From: "John Ridout"
Date:
Subject: MS Access upsizing