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