From: jaime soler <jaime.soler@gmail.com>
To: john@jpm-cola.com
Cc: pgsql-admin@postgresql.org
Subject: Re: Single Database Recovery?
Date: Thu, 23 Oct 2014 16:26:21 +0200
Message-ID: <1414074381.25413.1.camel@gmail.com> (raw)
In-Reply-To: <20141023064401.569d35d6ab57613ee80d5d1694a397ee.da2ef0c184.wbe@email06.secureserver.net>
References: <20141023064401.569d35d6ab57613ee80d5d1694a397ee.da2ef0c184.wbe@email06.secureserver.net>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
El jue, 23-10-2014 a las 06:44 -0700, john@jpm-cola.com escribió:
>
>
> 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?
No, if you have a physical backup with all archive files, you will able
to restore the whole instance. It's not posible to restore only a
database with a physical backup.
> 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.
>
>
> I also know that I could easily create a new instance but I have a
> constraint that the IP addresses and ports cannot be changed.
>
>
> If this instance only had a single database it would be a simple
> physical restore, but the presence of the additional databases has me
> stumped.
>
>
> The PostgreSQL version is 9.1.9. The server is Red Hat Enterprise
> Linux Server release 6.2 (Santiago) on a VM machine - 8 GB RAM with 2
> CPUs:
>
>
> Architecture: x86_64
> CPU op-mode(s): 32-bit, 64-bit
> Byte Order: Little Endian
> CPU(s): 2
> On-line CPU(s) list: 0,1
> Thread(s) per core: 1
> Core(s) per socket: 2
> CPU socket(s): 1
> NUMA node(s): 1
> Vendor ID: GenuineIntel
> CPU family: 6
> Model: 44
> Stepping: 2
> CPU MHz: 2660.000
> BogoMIPS: 5320.00
> L1d cache: 32K
> L1i cache: 32K
> L2 cache: 256K
> L3 cache: 12288K
> NUMA node0 CPU(s): 0,1
>
>
> Thanks for any ideas or myth debunking that you can apply to this
> conundrum.
>
>
> Regards,
>
>
> John McDougald
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: jaime.soler@gmail.com, john@jpm-cola.com
Subject: Re: Single Database Recovery?
In-Reply-To: <1414074381.25413.1.camel@gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox