Did you connect as the backup user to the db and check what the
statement_timeout is from that perspective? It's a locally settable
var by db and by user, so it's still possible you'll get bit by this
again if it's set for the backup user or just for that db.
On Tue, Jan 10, 2012 at 1:13 PM, akp
vacuum_cost_delay = 2ms ,
I set it as 20ms. last night I did not see any timeouts during the back up.
But I don't understand that. Thanks a lot for the support
On Mon, Jan 9, 2012 at 7:17 PM, Scott Marlowe wrote:
> On Mon, Jan 9, 2012 at 1:06 PM, Scott Marlowe
> wrote:
> > On Mon, Jan 9, 2012 at
On Mon, Jan 9, 2012 at 1:06 PM, Scott Marlowe wrote:
> On Mon, Jan 9, 2012 at 12:37 PM, akp geek 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 back
On Mon, Jan 9, 2012 at 12:37 PM, akp geek 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;
--
I have the replication set up and I am running the pg_dump against the
master
Thanks
On Mon, Jan 9, 2012 at 2:33 PM, Adrian Klaver wrote:
> On Monday, January 09, 2012 11:16:46 am akp geek wrote:
> > I am using pg_dump to back up each schema in the database and there 6
> > schemas in the databa
I have statement_timeout as commented in the postgresql.conf. I just
checked it..
Thanks
On Mon, Jan 9, 2012 at 2:31 PM, Scott Marlowe wrote:
> On Mon, Jan 9, 2012 at 11:05 AM, akp geek wrote:
> > Hi All -
> >
> > During the backup of the database, we experience timeout
> on
>
On Monday, January 09, 2012 11:16:46 am akp geek wrote:
> I am using pg_dump to back up each schema in the database and there 6
> schemas in the database.
Do you have replication set up and if so are running the above against the
master or the standby?
>
> thanks
>
--
Adrian Klaver
adrian.kl
On Mon, Jan 9, 2012 at 11:05 AM, akp geek 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
I am using pg_dump to back up each schema in the database and there 6
schemas in the database.
thanks
On Mon, Jan 9, 2012 at 1:26 PM, Jerry Sievers wrote:
> akp geek writes:
>
> > Hi All -
> >
> > ? ? ? ? ? ? ? ? During the backup of the database, we experience
> > timeout on queries. any one h
akp geek writes:
> 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
What backup method and what statement
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
Regards
11 matches
Mail list logo
