Обсуждение: 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
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 >