Postgres Pro
Downloads
Home   >   mailing lists

Re: disabling log_min_duration_statement from pg_dump? - Mailing list pgsql-hackers

From Tom Lane
Subject Re: disabling log_min_duration_statement from pg_dump?
Date
Msg-id 23207.1268083531@sss.pgh.pa.us
Whole thread Raw
In response to disabling log_min_duration_statement from pg_dump?  (Jaime Casanova <jcasanov@systemguards.com.ec>)
Responses Re: disabling log_min_duration_statement from pg_dump?
List pgsql-hackers
Tree view 
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

pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: SQL compatibility reminder: MySQL vs PostgreSQL
Next
From: Jaime Casanova
Date:
Subject: Re: disabling log_min_duration_statement from pg_dump?