Upgrading database format on PostgreSQL 8.1 on FC6

Поиск
Список
Период
Сортировка
От Arjun Datta
Тема Upgrading database format on PostgreSQL 8.1 on FC6
Дата
Msg-id 489364A6.2050701@greatgulfhomes.com
обсуждение исходный текст
Ответы Re: Upgrading database format on PostgreSQL 8.1 on FC6
Список 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@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 по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: How do I specify an interval in a function?
Следующее
От: Steve Crawford
Дата:
Сообщение: Re: Upgrading database format on PostgreSQL 8.1 on FC6