Postgres Pro
Downloads
Home   >   mailing lists

Re: [GENERAL] Restore single databaseR - Mailing list pgsql-general

From PAWAN SHARMA
Subject Re: [GENERAL] Restore single databaseR
Date
Msg-id CAPgXFMRUCAA7WwMneiJZCQ0jifuacT7pCdd_tbmyJcuFxvaprw@mail.gmail.com
Whole thread Raw
In response to Re: [GENERAL] Restore single databaseR  (Vick Khera <vivek@khera.org>)
Responses Re: [GENERAL] Restore single databaseR  (Moreno Andreo <moreno.andreo@evolu-s.it>)
List pgsql-general
Tree view
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 having 50 databases and I want to move all databases running on instance A to another server having same postgres version and server configuration.

So,please suggest how i can move instance A to another server.

On 18 Jan 2017 7:10 p.m., "Vick Khera" <vivek@khera.org> wrote:
On Wed, Jan 18, 2017 at 7:32 AM, PAWAN SHARMA <er.pawanshr0963@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.

pgsql-general by date:

Previous
From: Vick Khera
Date:
Subject: Re: [GENERAL] Restore single databaseR
Next
From: Moreno Andreo
Date:
Subject: Re: [GENERAL] Restore single databaseR