Upgrade 7.0.3 -> 7.1.3 problems!

From: David Link <dlink(at)soundscan(dot)com>
To: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Upgrade 7.0.3 -> 7.1.3 problems!
Date: 2002-01-29 16:54:45
Message-ID: 3C56D3D5.8378FC4B@soundscan.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi.

I'm trying to upgrade from 7.0.3 to 7.1.3 and I now have neither
working.

I made a dump file of my one database of interest.

I downloaded
postgresql-7.1.3-1PGDG.i686.rpm
postgresql-perl-7.1.3-1PGDG.i686.rpm
postgresql-server-7.1.3-1PGDG.i686.rpm

I used rpmdrake (Mandrake 8.0) to install them. And Ok.

I set up $PGDATA to point to a new place.

Ran initdb -- A-Okay.

I got message /usr/lib/libpg.so.2 not found. So I copied it back over
from /var/lib/pgsql/backup/ and things started working...

Started postmaster as the postgres user and OK. (But if I try to start
it as root with "/etc/init.d/postgresql start" I get error message --

Error:
An old version of the database format was found.\nYou need to upgrade
the data format before using PostgreSQL.\nSee (Your System's
documentation directory)/postgresql-7.1.2/README.rpm-dist for more
information.
)

As postgres I can "createdb foo". However when I try to use the psql
client I get error message:

Error:
psql: error while loading shared libraries: psql: undefined symbol:
PQgetssl
pq_recvbuf: unexpected EOF on client connection.

And I not have been unable to find any information on PQgetssl.

Can anybody tell me what's going on?

Thanks, David

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Frank Joerdens 2002-01-29 17:00:38 Re: Multibyte encoding vs. SQL_ASCII vs. locales and European languages
Previous Message Jason Earl 2002-01-29 16:35:33 Re: job scheduling