From: | PAWAN SHARMA <er(dot)pawanshr0963(at)gmail(dot)com> |
---|---|
To: | Vick Khera <vivek(at)khera(dot)org> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Restore single databaseR |
Date: | 2017-01-18 14:01:48 |
Message-ID: | CAPgXFMRUCAA7WwMneiJZCQ0jifuacT7pCdd_tbmyJcuFxvaprw@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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(at)khera(dot)org> wrote:
> 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 | Moreno Andreo | 2017-01-18 14:33:13 | Re: Restore single databaseR |
Previous Message | Vick Khera | 2017-01-18 13:40:46 | Re: Restore single databaseR |