| From: | Vick Khera <vivek(at)khera(dot)org> |
|---|---|
| To: | PAWAN SHARMA <er(dot)pawanshr0963(at)gmail(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Restore single databaseR |
| Date: | 2017-01-18 13:40:46 |
| Message-ID: | CALd+dcekpy9+2YvuyhzvEW4DcCbF6eYGMw6fDZo4r34hYWmYuA@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Wed, Jan 18, 2017 at 7:32 AM, PAWAN SHARMA <er(dot)pawanshr0963(at)gmail(dot)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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | PAWAN SHARMA | 2017-01-18 14:01:48 | Re: Restore single databaseR |
| Previous Message | PAWAN SHARMA | 2017-01-18 12:32:37 | Restore single databaseR |