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