Re: Upgrade Data from 7.x.x to 8.x.x

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Upgrade Data from 7.x.x to 8.x.x
Дата
Msg-id 6063.1118025821@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Upgrade Data from 7.x.x to 8.x.x  ("Patrick Brennan" <patrick.brennan@bsdfirst.com>)
Список pgsql-admin
"Patrick Brennan" <patrick.brennan@bsdfirst.com> writes:
> Hopefully a simple question.  I have a copy of the data from an old
> PostgreSQL installation (it's not a dump, it's a copy of the PGDATA
> directory).  I have two questions, is there a simple way for me to
> determine the version of PostgreSQL that this data belongs to?

Read the PG_VERSION file that appears at the top level.

> Secondly, is there anyway to import this data into PostgreSQL 8.0
> without need to run a 7.x postmaster?

No.  You need to run a matching 7.x postmaster and do pg_dumpall.

            regards, tom lane

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: unable to GRANT on sequence
Следующее
От: Michael Fuhr
Дата:
Сообщение: Re: unable to GRANT on sequence