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