Re: Upgrade 7.0.3 -> 7.1.3 problems! - Mailing list pgsql-general

From Tom Lane
Subject Re: Upgrade 7.0.3 -> 7.1.3 problems!
Date
Msg-id 15429.1012330954@sss.pgh.pa.us
Whole thread Raw
In response to Re: Upgrade 7.0.3 -> 7.1.3 problems!  (David Link <dlink@soundscan.com>)
List pgsql-general
David Link <dlink@soundscan.com> writes:

> postgres$ initdb
> root# /etc/init.d/postgresql start

> An old version of the database format was found.\n

AFAICS that message doesn't appear anywhere in the PG distribution,
so I suppose it must be coming out of the /etc/init.d/postgresql script.
Better look at that script and see what it's unhappy about.  A first
guess is that the data directory you initialized with "initdb" is not
the same data directory that the start script is expecting to use.
Check $PGDATA settings and/or -D arguments.

> psql: error while loading shared libraries: psql: undefined symbol:
> PQgetssl

This looks like psql was compiled with SSL support and libpq wasn't.
Are you sure you installed a complete set of compatible RPMs?  I'd
say one or the other file wasn't updated.

            regards, tom lane

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Multibyte encoding vs. SQL_ASCII vs. locales and European languages
Next
From: Tom Lane
Date:
Subject: Re: Multibyte encoding vs. SQL_ASCII vs. locales and European languages