Re: HOW-TO migrate database

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: HOW-TO migrate database
Дата
Msg-id 25373.995388342@sss.pgh.pa.us
обсуждение исходный текст
Ответ на HOW-TO migrate database  ("Marian Sabo" <sabo@cps.sk>)
Ответы Re: HOW-TO migrate database  (SUVRANSHU KAR <suvranshu_k@yahoo.com>)
Список pgsql-admin
"Marian Sabo" <sabo@cps.sk> writes:
> I have a many databases on server "one" in postgres-6.5.2
> How can I copy my databases to a new server with new postgres vsersion
> (7.1.2) ?
> on first server I run : pg_dumpall -o > outputfile, but on new server
> pg_restore don't understand the data format.

pg_dumpall is the right approach, though I would not recommend using -o.

Possibly you will need to do a little bit of editing to cope with
changes from 6.5 to 7.1, although it surprises me to hear it.  What
problems are you seeing, exactly, when you try to load the dump script?

            regards, tom lane

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Problem: plperl load failed (PGSQL 7.1.2)
Следующее
От: LA
Дата:
Сообщение: Permission