Skip site navigation (1) Skip section navigation (2)

Re: Upgrade 7.0.3 -> 7.1.3 problems!

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: David Link <dlink(at)soundscan(dot)com>
Cc: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Upgrade 7.0.3 -> 7.1.3 problems!
Date: 2002-01-29 19:02:34
Message-ID: 15429.1012330954@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-general
David Link <dlink(at)soundscan(dot)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

In response to

Responses

pgsql-general by date

Next:From: Tom LaneDate: 2002-01-29 19:14:33
Subject: Re: Multibyte encoding vs. SQL_ASCII vs. locales and European languages
Previous:From: Tom LaneDate: 2002-01-29 18:54:04
Subject: Re: Multibyte encoding vs. SQL_ASCII vs. locales and European languages

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group