On Mon, Jan 9, 2012 at 1:06 PM, Scott Marlowe <scott.marlowe@xxxxxxxxx> wrote: > On Mon, Jan 9, 2012 at 12:37 PM, akp geek <akpgeek@xxxxxxxxx> wrote: >> I have statement_timeout as commented in the postgresql.conf. I just >> checked it.. > > statement timeout, like so many things, can be set per user or per > database. Connect as the backup use and issue this statement: > > show statement_timeout; The other possibility is that you're getting a network timeout while waiting for a response to a select statement. Most network timeouts are ~2 hours, but if you've got a firewall look at timeouts. Any timeouts should be disabled to troubleshoot. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
