Re: Upgrade db format without older version of PostgreSQL

Поиск
Список
Период
Сортировка
От Filip Rembiałkowski
Тема Re: Upgrade db format without older version of PostgreSQL
Дата
Msg-id 92869e660909290929x38b7c4e6xa27eb7f630a98ce0@mail.gmail.com
обсуждение исходный текст
Ответ на Upgrade db format without older version of PostgreSQL  (Kelly Jones <kelly.terry.jones@gmail.com>)
Список pgsql-general


2009/9/29 Kelly Jones <kelly.terry.jones@gmail.com>
I recently upgraded PostgreSQL, and now this happens:

# /etc/init.d/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.3.8/README.rpm-dist for more information.


apparently your upgrade procedure was far from perfect.

 

Unfortunately, I upgraded due to a hardware failure, and can't
dump/undump, since I don't have the old PostgreSQL server anymore.

Can I upgrade the data format w/o installing Postgres 7.2 (my
"data/base/1/PG_VERSION" file says "7.2")?


no.
 
If not, can Fedora 11's "yum" install Postgres 7.2 (so I can at least
do a clean install/uninstall and then re-install 8.3.8)?


Don't know, but I'd rather try this:

compile 7.2 from source, bring up a temporary postgres 7.2 instance, dump it (using pg_dumpall from 8.3), and load the dump into 8.3.


--
Filip Rembiałkowski
JID,mailto:filip.rembialkowski@gmail.com
http://filip.rembialkowski.net/

В списке pgsql-general по дате отправления:

Предыдущее
От: Kelly Jones
Дата:
Сообщение: Upgrade db format without older version of PostgreSQL
Следующее
От: Devrim GÜNDÜZ
Дата:
Сообщение: Re: Upgrade db format without older version of PostgreSQL