Re: Upgrade 7.0.3 -> 7.1.3 problems!

Further information -- Here it is a little clearer:

1. ) Reinstall 7.0.3:

root#  rpm -v --force -i postgresql-server-7.0.3-2mdk.i586.rpm
postgresql-7.0.3-2mdk.i586.rpm
root#  /etc/init.d/postgresql status
root#  /etc/init.d/postgresql restart
postgres$ initdb
postgres$ createdb tmpdb
postgres$ psql -d tmpdb

EVERYTHING WORKS.

2. ) Reinstall 7.1.3:

root# /etc/init.d/postgresql stop
root# rpm -v --force -i postgresql*7.1.3*rpm
  postgresql-7.1.3-1PGDG
  postgresql-perl-7.1.3-1PGDG
  postgresql-server-7.1.3-1PGDG
postgres$ initdb
root# /etc/init.d/postgresql start

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.

postgres$ postmaster &
postgres$ createdb tmpdb
postgres$ psql -d tmpdb

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

Anybody? Thanks - David



David Link wrote:
>
> 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
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org