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.
