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.