From: Sebastian Reitenbach <sebastia@l00-bugdead-prods.de>
To: pgsql-admin@postgresql.org
Subject: trigger run of archive_command?
Date: Mon, 14 Jan 2008 17:10:20 +0100
Message-ID: <20080114161020.A83E23A672@smtp.l00-bugdead-prods.de> (raw)
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: sebastia@l00-bugdead-prods.de
Subject: Re: trigger run of archive_command?
In-Reply-To: <20080114161020.A83E23A672@smtp.l00-bugdead-prods.de>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox