Re: [GENERAL] set statement_timeout does not work

2010-03-30 Thread Scott Marlowe
On Mon, Mar 29, 2010 at 8:33 PM, Jun Wang wrote: > Hi, > > I try to set the statement_timeout so that "select pg_stop_backup();" > will not hang if archive command failed. Below are the command and > errors. > Try it by putting the commands in a file and running it like psql . -f mysqlfile.s

Re: [GENERAL] set statement_timeout does not work

2010-03-30 Thread Jun Wang
Hi, I try to set the statement_timeout so that "select pg_stop_backup();" will not hang if archive command failed. Below are the command and Can somebody help on this? Thanks. * From: Ju

[GENERAL] set statement_timeout does not work

2010-03-29 Thread Jun Wang
Hi, I try to set the statement_timeout so that "select pg_stop_backup();" will not hang if archive command failed. Below are the command and errors. psql.exe" -d mydb -h myhost -p 5432 -U postgres -w -c "set statement_timeout = 1000; select pg_stop_backup();" WARNING: pg_stop_backup still waitin