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 ?
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 по дате отправления: