On Wed, Jan 18, 2017 at 7:32 AM, PAWAN SHARMA <er.pawanshr0...@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.

Reply via email to