Received: from localhost (unknown [200.46.204.182]) by postgresql.org (Postfix) with ESMTP id E0DC62E3540 for ; Mon, 14 Jan 2008 12:39:45 -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 84960-03 for ; Mon, 14 Jan 2008 12:39:37 -0400 (AST) Received: from smtp.l00-bugdead-prods.de (smtp.l00-bugdead-prods.de [212.204.53.48]) by postgresql.org (Postfix) with ESMTP id 53EA42E3417 for ; Mon, 14 Jan 2008 12:39:37 -0400 (AST) Received: by smtp.l00-bugdead-prods.de (Postfix, from userid 1001) id EB8D83A6F7; Mon, 14 Jan 2008 17:39:34 +0100 (CET) organization: L00 bugdead prods. cc: pgsql-admin@postgresql.org X-Mailer: OpenGroupware.org MIME-Version: 1.0 from: "Sebastian Reitenbach" Subject: Re: trigger run of archive_command? reply-to: "Sebastian Reitenbach" content-type: text/plain; charset="us-ascii" date: Mon, 14 Jan 2008 17:39:34 +0100 content-transfer-encoding: 7bit Message-Id: <20080114163934.EB8D83A6F7@smtp.l00-bugdead-prods.de> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200801/148 X-Sequence-Number: 27922 Hi, Thomas Karcher wrote: > Hi, > > > 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. > > I guess what you want is pg_switch_xlog() (see > http://www.postgresql.org/docs/8.2/static/functions-admin.html) this is exactly what I am looking for > which became available with PG 8.2 ... unfortunately right now I am stuck to PG 8.1.4. I hope I can manage to upgrade without too much hassle, it seems meanwhile I have to use my workaround. thanks a lot Sebastian