Received: from localhost (unknown [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id 83FF79FBA15 for ; Thu, 11 Oct 2007 11:50:57 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-maia, port 10024) with ESMTP id 33623-01-3 for ; Thu, 11 Oct 2007 11:50:51 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.5 Received: from mail.gmx.net (mail.gmx.net [213.165.64.20]) by postgresql.org (Postfix) with SMTP id A2FB19FBA1C for ; Thu, 11 Oct 2007 11:50:46 -0300 (ADT) Received: (qmail invoked by alias); 11 Oct 2007 14:50:43 -0000 Received: from secure.wh4f.de (EHLO [192.168.107.6]) [81.169.136.22] by mail.gmx.net (mp028) with SMTP; 11 Oct 2007 16:50:43 +0200 X-Authenticated: #608320 X-Provags-ID: V01U2FsdGVkX18avktQPiMaTuaOYgOoZnFWgaE5tSJ1ofuJjdqgg6 XdpAQwKtZ3hFeW Subject: Re: Consistent PITR backup From: Thomas Karcher To: Tom Lane Cc: pgsql-admin@postgresql.org In-Reply-To: <13579.1192114043@sss.pgh.pa.us> References: <20071011093908.GA7988@arche.mine.nu> <13019.1192112569@sss.pgh.pa.us> <1192113425.9842.2.camel@localhost.localdomain> <13579.1192114043@sss.pgh.pa.us> Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="=-QgjjawOME388JBPGhnMs" Date: Thu, 11 Oct 2007 16:50:38 +0200 Message-Id: <1192114238.9842.4.camel@localhost.localdomain> 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: 200710/94 X-Sequence-Number: 27008 --=-QgjjawOME388JBPGhnMs Content-Type: text/plain Content-Transfer-Encoding: quoted-printable Hi Tom, > >> I believe the intended way to do this is to look at pg_stop_backup's > >> return value to determine the last segment you need to archive. > > Thank you - I saw that, but I didn't have a clue about how to determine > > the WAL filename in which this segment is to be found ... > Well, the transformation is pretty trivial, but you can use > pg_xlogfile_name() to avoid getting your hands dirty. That's what I was looking for! Thank you! Best regards from Germany, Thomas --=-QgjjawOME388JBPGhnMs 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) iD8DBQBHDjg+iMyIQtYO79wRAr0ZAKCXrT5EBG+FAu6jLv8ioezgEJm8WQCgqRhY KEkFuRklFiBrchjaO/E/1Gw= =TT/f -----END PGP SIGNATURE----- --=-QgjjawOME388JBPGhnMs--