Postgres Pro
Downloads
Home   >   mailing lists

Re: queries timeout during backup postgres database - Mailing list pgsql-general

From Scott Marlowe
Subject Re: queries timeout during backup postgres database
Date
Msg-id CAOR=d=0jkE3G70wFYA1r-mb39UfWrVq3WNU--80XV-tmzVzApw@mail.gmail.com
Whole thread Raw
In response to queries timeout during backup postgres database  (akp geek <akpgeek@gmail.com>)
Responses Re: queries timeout during backup postgres database  (akp geek <akpgeek@gmail.com>)
List pgsql-general
Tree view 
On Mon, Jan 9, 2012 at 11:05 AM, akp geek <akpgeek@gmail.com> wrote:
> Hi All -
>
>                 During the backup of the database, we experience timeout on
> queries. any one has experienced the same? Is there any parameters in the
> postgressql.conf that I have to pay attention to? Can you please help

statement_timeout is the likely culprit.

pgsql-general by date:

Previous
From: akp geek
Date:
Subject: Re: queries timeout during backup postgres database
Next
From: Alban Hertroys
Date:
Subject: Re: Binary Large Objects (LOB/BLOB) in Hibernate and JDBC: Unresolved issues