Upgrading database format on PostgreSQL 8.1 on FC6

From: Arjun Datta <arjun(at)greatgulfhomes(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: Upgrading database format on PostgreSQL 8.1 on FC6
Date: 2008-08-01 19:31:50
Message-ID: 489364A6.2050701@greatgulfhomes.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

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(at)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(at)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

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Steve Crawford 2008-08-01 20:43:29 Re: Upgrading database format on PostgreSQL 8.1 on FC6
Previous Message Tom Lane 2008-07-31 00:59:11 Re: How do I specify an interval in a function?