Re: Switch log (WAL)

On Sun, Feb 12, 2006 at 11:47:11AM +0100, postgres@pivert.org wrote:
> Hello,
>
> I'm new to the list, and I'm intereted in PostgreSQL replication (using WAL)
> As I didn't find any script to do that, I make mine, that seems to work.
>
> However, I wonder how can I "switch WAL logs", in order to have the standby
> database not too much late.
> The database actually generates few logs, and I would like one WAL to be
> generated once per hour.
>
> How Can I do that ?

You can't. What you can do is copy the most recently touched log file as
often as you'd like. That will limit your data loss should you need to
fail-over.
--
Jim C. Nasby, Sr. Engineering Consultant      jnasby@pervasive.com
Pervasive Software      http://pervasive.com    work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf       cell: 512-569-9461