Обсуждение: ODP: I screwed it up, my installation :(

I am not sure but maybe this is a simple problem
with the PostgreSQL start-up script. The script
is /etc/rc.d/init.d/postgresql. There is version
checking in it, find line:

    if [ `cat /var/lib/pgsql/PG_VERSION` != '6.5' ]

or something like that (it depends of your instalation).
Then find your PG_VERSION file in your data directory,
check real number in the file (perhaps 7.0) and place
it in the script instead of your old version (perhaps 6.5).

This should help.

                        Mikolaj.

> Hi all,
>
> First a bit of background, I am using RH6.1 on intel and my
> window manager is HelixGnome with Sawfish.
>
> Now, I sure hope someone can help me, I started with a
> functioning pgsql 6.5.2-1 and decided to upgrade it with
> the current version 7.0.2-2. I saw on the Download page the
> comment about initdb and tried to find info about it,
> ending up in the Installation How-To so I followed it.
>
.....
>
> But then my problems really seemed to start (or at least now
> become apparent) because then when I tried to restart the
> postmaster service I got an error saying:
> Checking postgresql installation: old version. Need to
> Upgrade.See /usr/doc/postgresql-7.0/README.rpm for more
> information.
>
.....
>
> So please help me, I am desperate.
>
> Alan
> --

Thanks for the suggestion but the installation had updated
the start up script to read version 7.0, however the other
RPMs were not upgraded and were still 6.5. It all became
clear when I actually read the script.

I had to reinstall from the CD, so all done now :0)

Of course if I had read the README properly I would have
seen that version 7.0 doesnt run on RedHat 6.1 only 6.2,
duh.

As a suggestion to the powers though, perhaps it might be a
good idea to have the README contents on the download page,
or somewhere handy to it, I did try to find one but
couldn't.

Cheers
Alan

On Fri, 18 Aug 2000, Rybarczyk Mikolaj wrote regarding
"ODP: [ADMIN] I screwed it up, my installation :(": > I am
not sure but maybe this is a simple problem > with the
PostgreSQL start-up script. The script > is
/etc/rc.d/init.d/postgresql. There is version > checking in
it, find line: >
>     if [ `cat /var/lib/pgsql/PG_VERSION` != '6.5' ]
>
> or something like that (it depends of your instalation).
> Then find your PG_VERSION file in your data directory,
> check real number in the file (perhaps 7.0) and place
> it in the script instead of your old version (perhaps 6.5).
>
> This should help.
>
>                         Mikolaj.
>

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