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
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? |