Обсуждение: [BUGS] BUG #14503: restore single database
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. -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
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:
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.
On Tue, Jan 17, 2017 at 1:03 PM, <pawan.sharma2@cognizant.com> wrote: > How can we restore single database from base backup files only. > > I don't have pg_dump backup. This is not a bug. Please post to pgsql-general@postgresql.org for this kind of problem. -- Kevin Grittner EDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs