Question about Warm Standby
I set up a failover system with one primary server and one standby server.
In the standby server's log, I saw the lines like below:
Command for restore : copy "E:\archive\00000001000000000000004C"
"pg_xlog\RECOVERYXLOG"
The above line means that: the transaction log file 00000001000000000000004C
was copied and renamed to RECOVERYXLOG in the pg_xlog folder of the standby
server, right?
So the standby server only keeps each transaction log from the primary
server temporarily in its pg_xlog folder during the recovery procedure,
right?
Thanks.
Jack
On Tue, 2009-03-17 at 17:59 -0700, Jack W wrote:
I set up a failover system with one primary server and one standby
server.
In the standby server's log, I saw the lines like below:Command for restore : copy "E:\archive\00000001000000000000004C"
"pg_xlog\RECOVERYXLOG"The above line means that: the transaction log file
00000001000000000000004C was copied and renamed to RECOVERYXLOG in the
pg_xlog folder of the standby server, right?
So the standby server only keeps each transaction log from the primary
server temporarily in its pg_xlog folder during the recovery
procedure, right?
Yes, that is correct. That design allows us to restore continuously
without allowing the pg_xlog folder to grow in size.
--
Simon Riggs www.2ndQuadrant.com
PostgreSQL Training, Services and Support