| From: | Simon Riggs <simon(at)2ndQuadrant(dot)com> |
|---|---|
| To: | Jack W <dbdevelop2000(at)gmail(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Question about Warm Standby |
| Date: | 2009-03-18 07:15:51 |
| Message-ID: | 1237360551.3953.164.camel@ebony.2ndQuadrant |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Lincoln Yeoh | 2009-03-18 07:21:25 | Re: PostgreSQL versus MySQL for GPS Data |
| Previous Message | Scott Marlowe | 2009-03-18 06:29:26 | Re: Uploading data to postgresql database |