Re: Can't start PostgreSQL

Thank you all

Deleting the old data base cleared up the problem.


Ian


On Thu, 2006-07-27 at 15:59 -0500, Bruno Wolff III wrote:

On Thu, Jul 27, 2006 at 10:22:33 -0600,
  Ian Johnson <norules@telus.net> wrote:
> 
> I want to develop an application in PostgreSQL but when starting the
> service I get the following message:
> 
> An old version of the database format was found.
> You need to upgrade the data format before using PostgreSQL.
> See /usr/share/doc/postgresql-8.1.4/README.rpm-dist for more
> information.
> 
> I am running Fedora Core 5 but initially had built the system with
> Fedora Core 3, with PostgreSQL installed and automatically updated it
> over the past 2 years.  I may have created a test database 2 years ago
> which may be the source of the problem.  Is this the source of the
> problem?  I could find nothing in README.rpm-dist that helps.

That could certainly be the problem.

> I would appreciate any advice on how to deal with this problem.

Probably you want to delete the old database cluster and do a dbinit to create
a new one. The old one will probably be in /var/lib/pgsql/data .

---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
       choose an index scan if your joining column's datatypes do not
       match