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 Hemy,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
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 по дате отправления: