pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedlogfile
4+ messages / 4 participants
[nested] [flat]
* logfile
@ 2006-06-06 12:37 H.J. Sanders <hjs@rmax.nl>
2006-06-06 21:53 ` Re: logfile Jim C. Nasby <jnasby@pervasive.com>
0 siblings, 1 reply; 4+ messages in thread
From: H.J. Sanders @ 2006-06-06 12:37 UTC (permalink / raw)
To: pgsql-admin
I assume I do not understand the manual right (or my kind of english).
In PGSQL 7.4 I only want error situations in the logfile, and if an error
occurs as much as possible information like e.g. the sql statement.
I entered in postgresql.conf:
client_min_messages = error
log_min_messages = error
log_error_verbosity = terse
log_min_error_statement = error
log_statement = true
log_timestamp = true
but now all sql statements are always logged.
What did I do wrong? Can someone give the proper settings?
Many thanks
Henk Sanders
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: logfile
2006-06-06 12:37 logfile H.J. Sanders <hjs@rmax.nl>
@ 2006-06-06 21:53 ` Jim C. Nasby <jnasby@pervasive.com>
0 siblings, 0 replies; 4+ messages in thread
From: Jim C. Nasby @ 2006-06-06 21:53 UTC (permalink / raw)
To: H.J. Sanders <hjs@rmax.nl>; +Cc: pgsql-admin
On Tue, Jun 06, 2006 at 02:37:11PM +0200, H.J. Sanders wrote:
> I assume I do not understand the manual right (or my kind of english).
>
> In PGSQL 7.4 I only want error situations in the logfile, and if an error
> occurs as much as possible information like e.g. the sql statement.
>
> I entered in postgresql.conf:
>
> client_min_messages = error
> log_min_messages = error
> log_error_verbosity = terse
> log_min_error_statement = error
>
> log_statement = true
> log_timestamp = true
>
> but now all sql statements are always logged.
>
> What did I do wrong? Can someone give the proper settings?
log_statement = false. See docs for log_min_error_statement.
--
Jim C. Nasby, Sr. Engineering Consultant jnasby@pervasive.com
Pervasive Software http://pervasive.com work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461
^ permalink raw reply [nested|flat] 4+ messages in thread
* Logfile
@ 2010-10-29 19:46 Eduardo Sá dos Reis <eduardoreis@pjf.mg.gov.br>
2010-10-29 20:13 ` Re: Logfile Kevin Grittner <Kevin.Grittner@wicourts.gov>
0 siblings, 1 reply; 4+ messages in thread
From: Eduardo Sá dos Reis @ 2010-10-29 19:46 UTC (permalink / raw)
To: pgsql-admin
I have several databases installed on my Postgre 8.4.2.
I set the postgresql.conf so that all connections are logged in the log file.
Now I need to create another database but do not want the connections in this new database to be recorded in the Log Files. Can anyone help me?
Eduardo
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Logfile
2010-10-29 19:46 Logfile Eduardo Sá dos Reis <eduardoreis@pjf.mg.gov.br>
@ 2010-10-29 20:13 ` Kevin Grittner <Kevin.Grittner@wicourts.gov>
0 siblings, 0 replies; 4+ messages in thread
From: Kevin Grittner @ 2010-10-29 20:13 UTC (permalink / raw)
To: Eduardo Sá dos Reis <eduardoreis@pjf.mg.gov.br>; pgsql-admin
Eduardo Sá dos Reis<eduardoreis@pjf.mg.gov.br> wrote:
> I have several databases installed on my Postgre 8.4.2.
> I set the postgresql.conf so that all connections are logged in
> the log file.
> Now I need to create another database but do not want the
> connections in this new database to be recorded in the Log Files.
> Can anyone help me?
You might need to put the new database is a separate cluster -- both
the documentation and some quick testing suggest that the setting
can not be set at the database level.
-Kevin
^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2010-10-29 20:13 UTC | newest]
Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2006-06-06 12:37 logfile H.J. Sanders <hjs@rmax.nl>
2006-06-06 21:53 ` Jim C. Nasby <jnasby@pervasive.com>
2010-10-29 19:46 Logfile Eduardo Sá dos Reis <eduardoreis@pjf.mg.gov.br>
2010-10-29 20:13 ` Re: Logfile Kevin Grittner <Kevin.Grittner@wicourts.gov>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox