Re: pg_stop_backup() - Mailing list pgsql-admin

From Bruce Momjian
Subject Re: pg_stop_backup()
Date
Msg-id 201003171518.o2HFIPk02221@momjian.us
Whole thread Raw
In response to pg_stop_backup()  ("Vitaly Burshteyn" <vburshteyn@broadway.com>)
List pgsql-admin
Vitaly Burshteyn wrote:
> Out of curiosity,  any idea why every time I run select
> pg_stop_backup();  it goes into an infinite loop?  While the
> first part of this select pg_start_backup(?label?) works without
> any issues??

pg_start_backup() is waiting for the archives to be stored.  I would
look in the server logs to see if something if failing there.  9.0 will
have better feedback when pg_stop_backup hangs like that.

--
  Bruce Momjian  <bruce@momjian.us>        http://momjian.us
  EnterpriseDB                             http://enterprisedb.com

  PG East:  http://www.enterprisedb.com/community/nav-pg-east-2010.do

pgsql-admin by date:

Previous
From: "Vitaly Burshteyn"
Date:
Subject: pg_stop_backup()
Next
From: Simon Riggs
Date:
Subject: Re: pg_stop_backup()