Re: [HACKERS] now 6.4 - Mailing list pgsql-hackers

From Bruce Momjian
Subject Re: [HACKERS] now 6.4
Date
Msg-id 199806101853.OAA01654@candle.pha.pa.us
Whole thread Raw
In response to Re: [HACKERS] now 6.4  (dg@illustra.com (David Gould))
Responses Re: [HACKERS] now 6.4
List pgsql-hackers
>
> Bruce Momjian:
> > PG_VERSION is now 6.4.  initdb everyone.  Or did we decide not to do
> > this if we could help it.  I think we will still need to run initdb, and
> > move the data files.
>
> I had thought we were going to avoid changing this unless there were changes
> to persistant structures. Do you know what changed to require this?
>
> Thanks

The contents of the system tables are going to change between releases,
almost for sure.  What I think we are going to do is have people pg_dump
-schema their databases, mv /data to /data.old, run initdb, run to
create the old schema, and move the data/index files back into place.
I will probably write the script and have people test it.

As long as we don't change the data/index structure, we are OK.  Is that
good, or did you think we would be able to get away without system table
changes?


--
Bruce Momjian                          |  830 Blythe Avenue
maillist@candle.pha.pa.us              |  Drexel Hill, Pennsylvania 19026
  +  If your life is a hard drive,     |  (610) 353-9879(w)
  +  Christ can be your backup.        |  (610) 853-3000(h)

pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: [HACKERS] Re: [PATCHES] Try again: S_LOCK reduced contention
Next
From: dg@illustra.com (David Gould)
Date:
Subject: Re: [HACKERS] now 6.4