It seems you were running a pre-8.x postgresql version before, its
data files are not compatible with the new version you have now.
You'll need to find out the version that used to be installed by
looking at the PG_VERSION file in your postgres data directory.
Once you do that you will need to install the old version (you can
download it from postgresql.org), start it against the database
directory and dump the databases. You can use pg_dumpall for this.
Once you have dumped the dbs, you can move the old data directory
aside, and run initdb for the new postgresql (8.1.4) and start it.
Then import the databases you previously dumped.
hth,
-Casey
On Jul 27, 2006, at 9:22 AM, Ian Johnson wrote:
Hi List
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.
I would appreciate any advice on how to deal with this problem.
Thank you
Ian Johnson
---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
