Re: Upgrade 7.0.3 -> 7.1.3 problems!

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