From: | lst_hoe02(at)kwsoft(dot)de |
---|---|
To: | pgsql-admin(at)postgresql(dot)org |
Subject: | Re: Single Database Recovery? |
Date: | 2014-10-23 16:18:09 |
Message-ID: | 20141023181809.Horde.ommW5Ym0XvlPF_F-8CLXlg1@webmail.kwsoft.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Zitat von john(at)jpm-cola(dot)com:
> Hi all,
>
> I'm trying to recover a single database that's part of an instance with
> other databases which I do not want to recover. We do a physical backup and
> have the WAL archive files available. The purpose of this is to place a
> copy of one of the Prod databases onto the QA server which has other
> existing databases that we want to keep.
>
> What I was thinking was that I could recover all of the files to a separate
> area, then basically just copy the files from that database's directory
> into the QA instance database directory (same oid.) There was an existing
> copy on the QA server and I want to replace it with the new copy.
>
> Is this possible? I know that I could simply do a pg_dump into this QA
> database but this seems to take way too long - days instead of the hours
> that it takes to unzip the physical backup file into a directory on the QA
> server.
>
Have you tried to simple use pg_dump piped to a psql feeding the data
directly in the target QA database? It has the advantage of not using
local temporary storage and should be reasonable fast in the range of
< TB.
Regards
Andreas
From | Date | Subject | |
---|---|---|---|
Next Message | Iñigo Salvat | 2014-10-23 19:33:27 | Re: Single Database Recovery? |
Previous Message | jaime soler | 2014-10-23 14:26:21 | Re: Single Database Recovery? |