Re: switch WAL segment - Mailing list pgsql-hackers

From Manfred Spraul
Subject Re: switch WAL segment
Date
Msg-id 4117CCEF.1010405@colorfullife.com
Whole thread Raw
In response to switch WAL segment  (Andreas Pflug <pgadmin@pse-consulting.de>)
List pgsql-hackers
Andreas Pflug wrote:

> Tom Lane wrote:
>
>> Do we have a TODO for allowing users to
>> force switching to a new WAL file segment?
>
>
> Together with PITR, this might make sense?
>
Another idea:
Has anyone tried to put the WAL segment directory on a cluster 
filesystem and use that for cold (perhaps even hot) failover?
The archive script could apply completed wal segments to the backup 
node. If the primary node fails, the last (partial) segment is applied 
as well and the backup node is activated.

--   Manfred




pgsql-hackers by date:

Previous
From: Gaetano Mendola
Date:
Subject: Re: VACUUM DELAY
Next
From: Jan Wieck
Date:
Subject: Re: VACUUM DELAY