Postgres Pro
Downloads
Home   >   mailing lists

Upgrading database format on PostgreSQL 8.1 on FC6 - Mailing list pgsql-novice

From Arjun Datta
Subject Upgrading database format on PostgreSQL 8.1 on FC6
Date
Msg-id 489364A6.2050701@greatgulfhomes.com
Whole thread Raw
Responses Re: Upgrading database format on PostgreSQL 8.1 on FC6  (Steve Crawford <scrawford@pinpointresearch.com>)
List pgsql-novice
Tree view
Hi,

I have an older server I am trying to restore a dump onto.

The server is FC6 on an x86_64 machine:
2.6.22.14-72.fc6 #1 SMP Wed Nov 21 14:10:25 EST 2007 x86_64 x86_64 x86_64 GNU/Linux

PostgreSQL is:
[root@devdb3 8.1]# rpm -qa | grep postgres
mono-data-postgresql-1.1.17.1-5.fc6
postgresql-8.1.10-1.fc6
postgresql-libs-8.1.10-1.fc6
postgresql-server-8.1.10-1.fc6
compat-postgresql-libs-debuginfo-4-1PGDG%{dist}
postgresql-libs-8.1.10-1.fc6
postgresql-jdbc-8.1.407-1jpp.4
postgresql-docs-8.2.7-1PGDG

When I try to start postgresql I get a database format error:
[root@devdb3 8.1]# service postgresql start

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.10/README.rpm-dist for more information.

I read the file mentioned above but didn't really get any more information than what the error gave me. I can't tell whether there is a tool/utility that allows me to upgrade the data format without running postgresql itself.

Should I uninstall and reinstall Postgres 8.1 or can I fix the above without doing that ?

-- 
Regards,
Arjun Datta

Great Gulf Homes / Ashton Woods Homes
416 441 1262 x2822

pgsql-novice by date:

Previous
From: Tom Lane
Date:
Subject: Re: How do I specify an interval in a function?
Next
From: Steve Crawford
Date:
Subject: Re: Upgrading database format on PostgreSQL 8.1 on FC6