Re: [BUGS] BUG #14503: restore single database

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Re: [BUGS] BUG #14503: restore single database
Дата
Msg-id CAKFQuwaVEyxv_iHwP9x5j9bOsM5hy9d=yWcP8rAC9Eo3YDzOkA@mail.gmail.com
обсуждение исходный текст
Ответ на [BUGS] BUG #14503: restore single database  (pawan.sharma2@cognizant.com)
Список pgsql-bugs
Дерево обсуждения
On Tue, Jan 17, 2017 at 12:03 PM, <pawan.sharma2@cognizant.com> wrote:
The following bug has been logged on the website:

Bug reference:      14503
Logged by:          Pawan Sharma
Email address:      pawan.sharma2@cognizant.com
PostgreSQL version: 9.5.5
Operating system:   Linux
Description:

How can we restore single database from base backup files only.

I don't have pg_dump backup.

​Not a bug.  Please direct usage question to pgsql-general@postgresql.org

That said:

​https://www.postgresql.org/docs/9.6/static/continuous-archiving.html#BACKUP-PITR-RECOVERY

You have to restore the entire cluster.  After you've done that you can pg_dump the single database you care about from the newly restored cluster and pg_restore it elsewhere.

David J.

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

Предыдущее
От: pawan.sharma2@cognizant.com
Дата:
Сообщение: [BUGS] BUG #14503: restore single database
Следующее
От: Kevin Grittner
Дата:
Сообщение: Re: [BUGS] BUG #14503: restore single database