Re: queries timeout during backup postgres database

On Mon, Jan 9, 2012 at 1:06 PM, Scott Marlowe <scott.marlowe@gmail.com> wrote:
> On Mon, Jan 9, 2012 at 12:37 PM, akp geek <akpgeek@gmail.com> 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.