Re: pg_dump from older version and pg_restore in newer

Поиск
Список
Период
Сортировка
От Shreeyansh dba
Тема Re: pg_dump from older version and pg_restore in newer
Дата
Msg-id CAGDYbUMZ+=Xji5wt2royVK0U6Yxvdju8dXvYwOdsT34GXgfjig@mail.gmail.com
обсуждение исходный текст
Ответ на pg_dump from older version and pg_restore in newer  ("Perry, Hemy" <hemy_perry@mentor.com>)
Ответы Re: pg_dump from older version and pg_restore in newer
Список pgsql-admin


On Sun, Jan 18, 2015 at 3:55 PM, Perry, Hemy <hemy_perry@mentor.com> wrote:

Hi,

 

I am planning  a migration from 9.1.7 to 9.4.0.

On many threads I noticed that the recommendation is “Be sure to use pg_dump from the *new* version to take the dump from the old database.

 

Is that a must?

Is there a chance that a restore using new version will fail because the dump was taken with *old* bin?

 

Regards

Hemy

 

 

Hi Hemy,

Using of new version dump is not a must. You can use dump of Older version(9.1.7) and use restore of New version(9.4.0)

Using restore of new version will not fail because the dump was taken with *old* bin.

This can fail only if you give any wrong syntax in command.


Hope this clears your issue.


-
Thanks & Regards,
Venkataramana Aitla
Database Administrator

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

Предыдущее
От: "Perry, Hemy"
Дата:
Сообщение: pg_dump from older version and pg_restore in newer
Следующее
От: "Perry, Hemy"
Дата:
Сообщение: Re: pg_dump from older version and pg_restore in newer