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  (PAWAN SHARMA <er.pawanshr0963@gmail.com>)
Список 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 по дате отправления:

Предыдущее
От: PAWAN SHARMA
Дата:
Сообщение: [GENERAL] Restore single databaseR
Следующее
От: PAWAN SHARMA
Дата:
Сообщение: Re: [GENERAL] Restore single databaseR