Received: from localhost (unknown [200.46.204.182]) by postgresql.org (Postfix) with ESMTP id BBCDA2E3069 for ; Mon, 14 Jan 2008 12:10:29 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.182]) (amavisd-maia, port 10024) with ESMTP id 70851-01 for ; Mon, 14 Jan 2008 12:10:25 -0400 (AST) Received: from smtp.l00-bugdead-prods.de (48.53.204.212.ediscom.de [212.204.53.48]) by postgresql.org (Postfix) with ESMTP id B21052E2F84 for ; Mon, 14 Jan 2008 12:10:24 -0400 (AST) Received: by smtp.l00-bugdead-prods.de (Postfix, from userid 1001) id A83E23A672; Mon, 14 Jan 2008 17:10:20 +0100 (CET) organization: L00 bugdead prods. X-Mailer: OpenGroupware.org MIME-Version: 1.0 from: "Sebastian Reitenbach" Subject: trigger run of archive_command? to: pgsql-admin@postgresql.org reply-to: "Sebastian Reitenbach" content-type: text/plain; charset="us-ascii" date: Mon, 14 Jan 2008 17:10:20 +0100 content-transfer-encoding: 7bit Message-Id: <20080114161020.A83E23A672@smtp.l00-bugdead-prods.de> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200801/144 X-Sequence-Number: 27918 Hi, I want to do online backup saving the WAL files. So I set the database into backup mode, make a backup, and then set the datbase to normal mode with pg_stop_backup(). To make the backup complete, I need to backup the actual WAL file too, but this one is still open when I run pg_stop_backup(), so I want to trigger the archive_command to be sure that I don't miss anything. In postgresql.conf I have defined an archive_command in postgresql.conf to tell postgres what to do when the WAL file reaches a maximum filesize. I use postgresql 8.1.4, so I only can make the archive_command depend on the size of the WAL files, right now the maximum size of a WAL file is defined to 16mb. As a workaround I could create a dummy table, insert 16MB to make sure the WAL files get rotated, and then I can backup the last WAL file. But my hope is that there is an easier way, e.g. do I can use a trigger to force the archive_command or any other mechanism? kind regards Sebastian