setting statement_timeout on live postmaster

[Warren Little]

Is there anyway to modify the statement_timeout value set
in postgresql.conf we creating a connection?
I would like to have the value set to something like 60 seconds on a
regular basis but my vacuumdb statements run longer and timeout without
completing the vacuum
--
Warren Little
Senior Vice President
Secondary Marketing
Security Lending Wholesale, LC
www.securitylending.com
Tel: [phone]
Fax: [phone]

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to ***@postgresql.org so that your
message can get through to the mailing list cleanly

[Bruce Momjian]

Post by Warren Little
Is there anyway to modify the statement_timeout value set
in postgresql.conf we creating a connection?
I would like to have the value set to something like 60 seconds on a
regular basis but my vacuumdb statements run longer and timeout without
completing the vacuum

Sure, use SET statement_timeout = 60000 in your session before the vacuum.