Re: [GENERAL] Restore single databaseR

2017-01-18 Thread Moreno Andreo
Hi, please don't top post. Il 18/01/2017 15:01, PAWAN SHARMA ha scritto: Thanks for reply, but I have 120 databases running on a one single instance. So it's not possible to take backup of instance instead of taking pg_dumb of all databases separately. Example: suppose we have two

Re: [GENERAL] Restore single databaseR

2017-01-18 Thread PAWAN SHARMA
Thanks for reply, but I have 120 databases running on a one single instance. So it's not possible to take backup of instance instead of taking pg_dumb of all databases separately. Example: suppose we have two instances running on single server, instance A having 120 databases and instance B

Re: [GENERAL] Restore single databaseR

2017-01-18 Thread Vick Khera
On Wed, Jan 18, 2017 at 7:32 AM, PAWAN SHARMA 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

[GENERAL] Restore single databaseR

2017-01-18 Thread PAWAN SHARMA
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. 2.How can we restore single instance on different server where