Hi all.
I’m pretty sure that this is a FAQ here, but I’ll ask it, just to get confirmation on what I need to do.
I have a database sitting on a box running PostgreSQL 8.4, checking in at 190GB. I performed a backup of the database, using pg_dump to get the data out of the database. This is a full level 0 backup of the database. I have WAL-based log shipping enabled on that server.
I just created a second database server that will be a recovery server, compiled and installed PostgreSQL onto it, and restored the full backup taken from the primary database onto it. Since this wasn’t a base backup (using tar, cpio, etc.), how would I apply the WAL logs to this secondary server, to get it up to current? All of the documentation I’ve read so far uses a base backup. Is there any way to apply the logs generated since that backup created by pg_dump to get the secondary database up to current?
Brad
* This e-mail and any files transmitted with it may contain confidential and/or privileged information and intended solely for the use of the individual or entity to whom they are addressed. If you are not the addressee or authorized to receive this for the addressee, you must not use, copy, disclose, or take any action based on this message or any information herein. If you have received this message in error, please advise the sender immediately by reply e-mail and delete this message.