Re: queries timeout during backup postgres database

From: Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>
To: akp geek <akpgeek(at)gmail(dot)com>
Cc: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: queries timeout during backup postgres database
Date: 2012-01-09 20:06:04
Message-ID: CAOR=d=3tfBzDuWebvQCCktSASk=+sEoZxA1s915cCLK_+oj6NQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Mon, Jan 9, 2012 at 12:37 PM, akp geek <akpgeek(at)gmail(dot)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;

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Oliver Jowett 2012-01-09 20:21:37 Re: [JDBC] Binary Large Objects (LOB/BLOB) in Hibernate and JDBC: Unresolved issues
Previous Message akp geek 2012-01-09 19:37:42 Re: queries timeout during backup postgres database