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
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 |