| From: | Jun Wang <junw2000(at)gmail(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | set statement_timeout does not work |
| Date: | 2010-03-30 02:33:55 |
| Message-ID: | deff9e831003291933k63585027h5afcc1451f91dd4e@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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 waiting for archive to complete (60
seconds elapsed)
WARNING: pg_stop_backup still waiting for archive to complete (120
seconds elapsed)
WARNING: pg_stop_backup still waiting for archive to complete (240
seconds elapsed)
WARNING: pg_stop_backup still waiting for archive to complete (480
seconds elapsed)
I also tried to run the two commands seperately as below. It also does not work.
psql.exe" -d mydb -h myhost -p 5432 -U postgres -w -c "set
statement_timeout = 1000;"
psql.exe" -d mydb -h myhost -p 5432 -U postgres -w -c "select pg_stop_backup();"
If I change the "statement_timeout" setting of postgresql.conf, it
works. But it will afftect all the queries.
How to use psql to do it?
Thanks.
Jack
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Faheem Mitha | 2010-03-30 04:50:38 | Re: simultaneously reducing both memory usage and runtime for a query |
| Previous Message | Vikram Patil | 2010-03-30 01:34:50 | Re: Floating point exception in initdb |