Re: Problems with vacuumdb

From: "Ignacio Colmenero" <ignacio(dot)colmenero(at)micotan(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Subject: Re: Problems with vacuumdb
Date: 2005-09-19 21:14:06
Message-ID: 20050919211408.AC21ABBC004@whelby.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

No. The statement_timeout parameter is set to 0.

Thanks.

-----------------------------------------------
Ignacio Colmenero
Software Development
Micotan Software Company Ltd.

-----Original Message-----
From: pgsql-general-owner(at)postgresql(dot)org
[mailto:pgsql-general-owner(at)postgresql(dot)org] On Behalf Of Tom Lane
Sent: September 19, 2005 2:36 PM
To: Ignacio Colmenero
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: [GENERAL] Problems with vacuumdb

"Ignacio Colmenero" <ignacio(dot)colmenero(at)micotan(dot)com> writes:
> I am receiving the following message when I do the vacuumdb process on a
> production database:
> vacuumdb: vacuuming of database "log" failed: ERROR: canceling query due
to
> user request

Do you have a statement_timeout limit set?

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Marc Munro 2005-09-19 23:04:46 Re: [pgsql-general] Daily digest v1.5557 (21 messages)
Previous Message Ignacio Colmenero 2005-09-19 21:03:06 Re: Problems with vacuumdb