Re: pg_stop_backup()

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