Received: from localhost (unknown [200.46.204.182]) by postgresql.org (Postfix) with ESMTP id 5A01D2E3294 for ; Mon, 14 Jan 2008 12:19:27 -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 72297-10 for ; Mon, 14 Jan 2008 12:19:21 -0400 (AST) Received: from mail.gmx.net (mail.gmx.net [213.165.64.20]) by postgresql.org (Postfix) with SMTP id 6E0B42E328E for ; Mon, 14 Jan 2008 12:19:21 -0400 (AST) Received: (qmail invoked by alias); 14 Jan 2008 16:19:19 -0000 Received: from unknown (EHLO [192.168.25.36]) [89.244.189.162] by mail.gmx.net (mp053) with SMTP; 14 Jan 2008 17:19:19 +0100 X-Authenticated: #608320 X-Provags-ID: V01U2FsdGVkX18P1H1FUvIPWCmVUuSI30htyLzvD9TW8o03C1GNex sh9RV8t2xF9677 Subject: Re: trigger run of archive_command? From: Thomas Karcher To: Sebastian Reitenbach Cc: pgsql-admin@postgresql.org In-Reply-To: <20080114161020.A83E23A672@smtp.l00-bugdead-prods.de> References: <20080114161020.A83E23A672@smtp.l00-bugdead-prods.de> Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="=-2nrRbmj+dPacOraZw3if" Date: Mon, 14 Jan 2008 17:19:18 +0100 Message-Id: <1200327558.4403.21.camel@localhost> Mime-Version: 1.0 X-Mailer: Evolution 2.10.3 X-Y-GMX-Trusted: 0 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200801/146 X-Sequence-Number: 27920 --=-2nrRbmj+dPacOraZw3if Content-Type: text/plain Content-Transfer-Encoding: quoted-printable Hi, > this one is still open when I run pg_stop_backup(), so I want to trigger = the=20 > archive_command to be sure that I don't miss anything.=20 I guess what you want is pg_switch_xlog() (see http://www.postgresql.org/docs/8.2/static/functions-admin.html) which became available with PG 8.2 ... Thomas --=-2nrRbmj+dPacOraZw3if Content-Type: application/pgp-signature; name=signature.asc Content-Description: Dies ist ein digital signierter Nachrichtenteil -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.6 (GNU/Linux) iD8DBQBHi4uGiMyIQtYO79wRAohRAJ46c8/MnGzdCofuiEy806iWL/be5QCfTpST ISPtB6J5SW36wQPcsXV/txc= =cMTR -----END PGP SIGNATURE----- --=-2nrRbmj+dPacOraZw3if--