Thread: disabling log_min_duration_statement from pg_dump?

Hi,

Every often, i analyze logs to find most slow queries... and every
time i found myself trying to ignore pg_dump's generated COPY commands
which could be very expensive...
can we add a parameter in pg_dump and pg_dumpall to disable
log_min_duration_statement?

--
Atentamente,
Jaime Casanova
Soporte y capacitación de PostgreSQL
Asesoría y desarrollo de sistemas
Guayaquil - Ecuador
Cel. +59387171157

Jaime Casanova <jcasanov@systemguards.com.ec> writes:
> can we add a parameter in pg_dump and pg_dumpall to disable
> log_min_duration_statement?

export PGOPTIONS="-c log_min_duration_statement=-1"

Or use ALTER USER SET to add that to the options for the account
you do pg_dump with; etc etc.
        regards, tom lane

On Mon, Mar 8, 2010 at 4:25 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> Jaime Casanova <jcasanov@systemguards.com.ec> writes:
>> can we add a parameter in pg_dump and pg_dumpall to disable
>> log_min_duration_statement?
>
> export PGOPTIONS="-c log_min_duration_statement=-1"
>

ah! so, that is PGOPTIONS for :)
and that works for every libpq application?

--
Atentamente,
Jaime Casanova
Soporte y capacitación de PostgreSQL
Asesoría y desarrollo de sistemas
Guayaquil - Ecuador
Cel. +59387171157

Jaime Casanova wrote:
> On Mon, Mar 8, 2010 at 4:25 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> > Jaime Casanova <jcasanov@systemguards.com.ec> writes:
> >> can we add a parameter in pg_dump and pg_dumpall to disable
> >> log_min_duration_statement?
> >
> > export PGOPTIONS="-c log_min_duration_statement=-1"
> >
> 
> ah! so, that is PGOPTIONS for :)
> and that works for every libpq application?

Yes.

--  Bruce Momjian  <bruce@momjian.us>        http://momjian.us EnterpriseDB
http://enterprisedb.com
 PG East:  http://www.enterprisedb.com/community/nav-pg-east-2010.do