From: | Lamar Owen <lamar(dot)owen(at)wgcr(dot)org> |
---|---|
To: | "Glerum, Joe - KyEM" <jglerum(at)kydes(dot)dma(dot)state(dot)ky(dot)us> |
Cc: | "'pgsql-general(at)postgresql(dot)org'" <pgsql-general(at)postgresql(dot)org>, "'pgsql-admin(at)postgresql(dot)org'" <pgsql-admin(at)postgresql(dot)org>, "'pgsql-novice(at)postgresql(dot)org'" <pgsql-novice(at)postgresql(dot)org> |
Subject: | Re: PG_VERSION Errors??? |
Date: | 2000-04-03 20:19:34 |
Message-ID: | 38E8FCD6.EF595AC4@wgcr.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin pgsql-general |
"Glerum, Joe - KyEM" wrote:
> Database system in directory /usr/local/pgsql/data is not compatable
> with this version of Postgres, or we are unable to read the PG_VERSION file.
> Explanation from the ValidatePgVersion: Version number in file
> '/usr/local/pgsql/data/PG_VERSION' should be 6.5, not 6.4.
> When I change the 6.4 to 6.5 and restart the postmaster I can't do so with
> errors to change it back to 6.4.
Did you do a dump/initdb/restore cycle? For a major version upgrade
(such s 6.4.2 to 6.5.3), you must first dump your old database using
pg_dumpall, clear out the database directory, initdb with the new
version, then restore using 'psql -e template1 <dumped-data-file'.
By the error message you gave, I'm assuming you are using the standard,
non-RPM distribution. The RPM distribution since 6.5.1 or so has
included a set of tools to make the migration easier. Upon an upgrade
of the RPM's, a copy of the old executables is saved; also, a
postgresql-dump utility is provided to use the old executables to make a
dump. Then, the new version can be started up.
--
Lamar Owen
WGCR Internet Radio
1 Peter 4:11
From | Date | Subject | |
---|---|---|---|
Next Message | Walter M. Yuan | 2000-04-03 21:17:49 | Re: PG_VERSION Errors??? |
Previous Message | Glerum, Joe - KyEM | 2000-04-03 19:17:46 | PG_VERSION Errors??? |
From | Date | Subject | |
---|---|---|---|
Next Message | Walter M. Yuan | 2000-04-03 21:17:49 | Re: PG_VERSION Errors??? |
Previous Message | Cdric Prvost | 2000-04-03 19:29:54 | word search |