<html><body><span style="font-family:Verdana; color:#000000; font-size:10pt;"><div><br></div><div>Hi all,</div><div><br></div><div>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.</div><div><br></div><div>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.</div><div><br></div><div>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.</div><div><br></div><div>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.</div><div><br></div><div>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. </div><div><br></div><div>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:</div><div><br></div><div style=""><div><font face="courier new, monospace">Architecture: x86_64</font></div><div><font face="courier new, monospace">CPU op-mode(s): 32-bit, 64-bit</font></div><div><font face="courier new, monospace">Byte Order: Little Endian</font></div><div><font face="courier new, monospace">CPU(s): 2</font></div><div><font face="courier new, monospace">On-line CPU(s) list: 0,1</font></div><div><font face="courier new, monospace">Thread(s) per core: 1</font></div><div><font face="courier new, monospace">Core(s) per socket: 2</font></div><div><font face="courier new, monospace">CPU socket(s): 1</font></div><div><font face="courier new, monospace">NUMA node(s): 1</font></div><div><font face="courier new, monospace">Vendor ID: GenuineIntel</font></div><div><font face="courier new, monospace">CPU family: 6</font></div><div><font face="courier new, monospace">Model: 44</font></div><div><font face="courier new, monospace">Stepping: 2</font></div><div><font face="courier new, monospace">CPU MHz: 2660.000</font></div><div><font face="courier new, monospace">BogoMIPS: 5320.00</font></div><div><font face="courier new, monospace">L1d cache: 32K</font></div><div><font face="courier new, monospace">L1i cache: 32K</font></div><div><font face="courier new, monospace">L2 cache: 256K</font></div><div><font face="courier new, monospace">L3 cache: 12288K</font></div><div style=""><font face="courier new, monospace" style="">NUMA node0 CPU(s): 0,1</font></div></div><div><br></div><div>Thanks for any ideas or myth debunking that you can apply to this conundrum.</div><div><br></div><div>Regards,</div><div><br></div><div>John McDougald</div></span></body></html>