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

From David Link
Subject Re: Upgrade 7.0.3 -> 7.1.3 problems!
Date
Msg-id 3C56FF6C.4BAE45F8@soundscan.com
Whole thread Raw
In response to Upgrade 7.0.3 -> 7.1.3 problems!  (David Link <dlink@soundscan.com>)
Responses Re: Upgrade 7.0.3 -> 7.1.3 problems!  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Tom Lane wrote:
>
> 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.

Right you are about this Tom.  I just found this out myself.  The
/etc/init.d/postgresql script has PGDATA hardcoded.  And I've gotten
past it.  Thanks.

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

What's a complete set?  What I thought all I needed was:
 postgresql-7.1.3-1PGDG.i686.rpm
 postgresql-perl-7.1.3-1PGDG.i686.rpm
 postgresql-server-7.1.3-1PGDG.i686.rpm

Do I need more?

Thank you much.!!

pgsql-general by date:

Previous
From: Frank Joerdens
Date:
Subject: Re: Multibyte encoding vs. SQL_ASCII vs. locales and European languages
Next
From: Jeff Anto
Date:
Subject: outer joins complexity