Zitat von john@xxxxxxxxxxxx:
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
Attachment:
smime.p7s
Description: S/MIME Cryptographic Signature
