Received: from maia.hub.org (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id 25E7C632FB3 for ; Thu, 18 Mar 2010 05:58:47 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 48049-05 for ; Thu, 18 Mar 2010 08:58:36 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from outmail129142.authsmtp.co.uk (outmail129142.authsmtp.co.uk [62.13.129.142]) by mail.postgresql.org (Postfix) with ESMTP id 4DAD663272C for ; Thu, 18 Mar 2010 05:58:35 -0300 (ADT) Received: from mail-c194.authsmtp.com (mail-c194.authsmtp.com [62.13.128.121]) by punt2.authsmtp.com (8.14.2/8.14.2/Kp) with ESMTP id o2I8wVxQ067743; Thu, 18 Mar 2010 08:58:31 GMT Received: from [192.168.0.4] (88-110-151-22.dynamic.dsl.as9105.com [88.110.151.22]) (authenticated bits=0) by mail.authsmtp.com (8.14.2/8.14.2/Kp) with ESMTP id o2I8wS3u008634; Thu, 18 Mar 2010 08:58:28 GMT Subject: Re: pg_stop_backup() From: Simon Riggs To: Vitaly Burshteyn Cc: pgsql-admin@postgresql.org In-Reply-To: <0F69574F9901D4459C6B75C9FF64FBC40483C59D@mxfl01.hollywoodmedia.corp> References: <31967793.169841268677217557.JavaMail.root@zimbra.int.journyx.com> <18735708.169861268677235843.JavaMail.root@zimbra.int.journyx.com> <0F69574F9901D4459C6B75C9FF64FBC40483C59D@mxfl01.hollywoodmedia.corp> Content-Type: text/plain Date: Thu, 18 Mar 2010 08:58:27 +0000 Message-Id: <1268902707.3827.1693.camel@ebony> Mime-Version: 1.0 X-Mailer: Evolution 2.26.1 Content-Transfer-Encoding: 7bit X-Server-Quench: 6ba8a9a9-326c-11df-80b9-0022640b883e X-AuthReport-Spam: If SPAM / abuse - report it at: http://www.authsmtp.com/abuse X-AuthRoute: OCdxZQATClZOTQEd DAteCiN5VAwpPBRK HVkIKg5MJUcNSQVJ NksadBtFaQ1bYFhD HGQLWlREUFV7XGt/ aQIfZQ1DY0tOQQRv UVZLQE1XHAJ3AVJe BGcWFXpxMgVGcHhz YQhgWnBfEkIoJE4s Sx9dCG4EYzR9aWFL Bl1Qd1FdbQNKfB1D blAtXHsONCtlM3Bw LCYfGhEXCH1HJxNO XgYVGlgbSkUWBn59 LwAA X-Authentic-SMTP: 61633235383639.1015:706/Kp X-AuthFastPath: 0 (Was 255) X-AuthVirus-Status: No virus detected - but ensure you scan with your own anti-virus system. X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-2.599 tagged_above=-10 required=5 tests=BAYES_00=-2.599 X-Spam-Level: X-Archive-Number: 201003/118 X-Sequence-Number: 33917 On Wed, 2010-03-17 at 10:41 -0400, Vitaly Burshteyn wrote: > Out of curiosity, any idea why every time I run select > pg_stop_backup(); it goes into an infinite loop? When you say "infinite" do you mean to say it never comes out of the loop at all? Not sure if you are reporting a bug, or not. The manual describes what is happening: http://developer.postgresql.org/pgdocs/postgres/continuous-archiving.html#BACKUP-BASE-BACKUP Step 5 Is there anything you think should be added to the manual? -- Simon Riggs www.2ndQuadrant.com