On Feb 28, 2008, at 12:51 PM, Alan Hodgson wrote:
On Thursday 28 February 2008, John Evans <admin@xxxxxxxxxx> wrote:
I've heard that upgrading to 8.2 or 8.3 will allow me to setup a
timeout value for WAL log creation, but upgrading at this time is
not an
option for various reasons.
Any insight that you can provide will be greatly appreciated!
Write a script that does "something" that results in 16MB of WAL
logging and
run it whenever you want a rotation to occur. Inserting a few hundred
thousand rows into an otherwise empty table should work. If it's not
indexed it won't impact your server much, especially if your normal
transaction volume is that low.
Or, even simpler:
SELECT pg_switch_xlog();
Erik Jones
DBA | Emma®
erik@xxxxxxxxxx
800.595.4401 or 615.292.5888
615.292.0777 (fax)
Emma helps organizations everywhere communicate & market in style.
Visit us online at http://www.myemma.com
---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@xxxxxxxxxxxxxx so that your
message can get through to the mailing list cleanly
