Re: [GENERAL] Restore single databaseR
| От | Vick Khera |
|---|---|
| Тема | Re: [GENERAL] Restore single databaseR |
| Дата | |
| Msg-id | CALd+dcekpy9+2YvuyhzvEW4DcCbF6eYGMw6fDZo4r34hYWmYuA@mail.gmail.com обсуждение исходный текст |
| Ответ на | [GENERAL] Restore single databaseR (PAWAN SHARMA <er.pawanshr0963@gmail.com>) |
| Ответы |
Re: [GENERAL] Restore single databaseR
|
| Список | pgsql-general |
On Wed, Jan 18, 2017 at 7:32 AM, PAWAN SHARMA <er.pawanshr0963@gmail.com> wrote:
Hello All,I am using postgres 9.5 enterprise edition and postgres 9.5 open source where i want know solution of two problems.1.How can we restore single database from base backup files only, I don't have pg_dump backup.
Restore the whole thing into a temporary instance of postgres and then pg_dump the database you want.
2.How can we restore single instance on different server where multiple instances are running on the production server.
Once you have the dump from pg_dump, you can restore it wherever you like. Chances are higher for success if the version numbers match or the destination is newer than the source.
В списке pgsql-general по дате отправления: