Re: [HACKERS] now 6.4
Bruce Momjian <maillist@candle.pha.pa.us>
From: Bruce Momjian <maillist@candle.pha.pa.us>
To: dg@illustra.com (David Gould)
Cc: hackers@postgreSQL.org
Date: 1998-06-10T18:51:56Z
Lists: 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)