Re: WAL archiving idle database - Mailing list pgsql-general

From Jeff Davis
Subject Re: WAL archiving idle database
Date
Msg-id 1193435219.7624.104.camel@dogma.ljc.laika.com
Whole thread Raw
In response to Re: WAL archiving idle database  (Erik Jones <erik@myemma.com>)
Responses Re: WAL archiving idle database
List pgsql-general
On Fri, 2007-10-26 at 16:31 -0500, Erik Jones wrote:
> In the absence of activity, WAL are archived every checkpoint_timeout
> seconds.  archive_timeout is how long postgres will wait for the
> archive_command to return before declaring it failed.
>

http://www.postgresql.org/docs/current/static/runtime-config-wal.html

"When this parameter is greater than zero, the server will switch to a
new segment file whenever this many seconds have elapsed since the last
segment file switch."

Regards,
    Jeff Davis


pgsql-general by date:

Previous
From: Jeff Davis
Date:
Subject: Re: WAL archiving idle database
Next
From: Tom Hart
Date:
Subject: Re: find out data types using sql or php