Re: trying to migrate to a new server.

Поиск
Список
Период
Сортировка
От Douglas McNaught
Тема Re: trying to migrate to a new server.
Дата
Msg-id 87ve9zemew.fsf@suzuka.mcnaught.org
обсуждение исходный текст
Ответ на trying to migrate to a new server.  (David Siebert <david@aretoo.com>)
Список pgsql-general
David Siebert <david@aretoo.com> writes:

> I have a very old postgres server that I am trying to move the data off
> of. It is running 7.1 and has been trouble free for 6 plus years.
> I am trying to move the data base off to a server running 8.1.
> I have managed to back up the data using PG_Dump using like this.
> " pg_dump -b -Fc -h stan.someplace.com -u phone >phone.data"

Use the 8.1 pg_dump to connect to the 7.1 database and generate a
backup.  Then the 8.1 pg_restore should be able to restore (new
versions of restore don't always understand old dump formats).

-Doug

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

Предыдущее
От: "Pavel Stehule"
Дата:
Сообщение: Re: set returning functions.
Следующее
От: "Scott Marlowe"
Дата:
Сообщение: Re: set returning functions.