Thread: Still trying to get pgsql to run

For the next installment, I have reinstalled the new version
of pgsql after having installed the older version and now
cannot get it to run. Any help would be appreciated.

This is what I get.

[root@alphabyte abyte]# /etc/rc.d/init.d/postgresql start
Checking postgresql installation: looks good!

Starting postgresql service: Database system in directory
/var/lib/pgsql is not compatible with this version of
Postgres, or we are unable to read the PG_VERSION file.
Explanation from ValidatePgVersion: Version number in file
'/var/lib/pgsql/PG_VERSION' should be 7.0 , not 6.5 .

No data directory -- can't proceed.
failed.
[root@alphabyte abyte]#


So I change P_VERSION to read 7.0 and get this:

[root@alphabyte abyte]# /etc/rc.d/init.d/postgresql start
Checking postgresql installation: old version. Need to Upgrade.
See /usr/doc/postgresql-6.5.2/README.rpm for more information.
[root@alphabyte abyte]#

Thanks
Alan


--
AlphaByte: PO Box 1941, Auckland, New Zealand
Specialising in:Graphic Design, Education and Training,
Technical Documentation, Consulting.
http://www.alphabyte.co.nz

I deleted all files and directories in /var/lib/pgsql/ and it
worked.

AlphaByteさんの<00082417171700.01419@alphabyte.co.nz>から
>For the next installment, I have reinstalled the new version
>of pgsql after having installed the older version and now
>cannot get it to run. Any help would be appreciated.
>
>This is what I get.
>
>[root@alphabyte abyte]# /etc/rc.d/init.d/postgresql start
>Checking postgresql installation: looks good!
>
>Starting postgresql service: Database system in directory
>/var/lib/pgsql is not compatible with this version of
>Postgres, or we are unable to read the PG_VERSION file.
>Explanation from ValidatePgVersion: Version number in file
>'/var/lib/pgsql/PG_VERSION' should be 7.0 , not 6.5 .
>
>No data directory -- can't proceed.
>failed.
>[root@alphabyte abyte]#
>
>
>So I change P_VERSION to read 7.0 and get this:
>
>[root@alphabyte abyte]# /etc/rc.d/init.d/postgresql start
>Checking postgresql installation: old version. Need to Upgrade.
>See /usr/doc/postgresql-6.5.2/README.rpm for more information.
>[root@alphabyte abyte]#
>
>Thanks
>Alan
>
>
>--
>AlphaByte: PO Box 1941, Auckland, New Zealand
>Specialising in:Graphic Design, Education and Training,
>Technical Documentation, Consulting.
>http://www.alphabyte.co.nz

Thanks, seems to have done the trick. Funny though because
the last time I tried that it didnt work, in fact it did
all kinds of nasty things.

Alan

On Thu, 24 Aug 2000, Aimin Pan wrote regarding "Re:
[ADMIN] Still trying to get pgsql to run":
> I deleted all files and directories in /var/lib/pgsql/
and it
> worked.
>

--
AlphaByte: PO Box 1941, Auckland, New Zealand
Specialising in:Graphic Design, Education and Training,
Technical Documentation, Consulting.
http://www.alphabyte.co.nz