Skip site navigation (1) Skip section navigation (2)

Migration of log features from 7.4 to 8.0

From: Szűcs Gábor <surrano(at)gmail(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Migration of log features from 7.4 to 8.0
Date: 2005-01-12 16:33:34
Message-ID: 41E5515E.5010307@gmail.com (view raw or flat)
Thread:
Lists: pgsql-adminpgsql-patches
Dear Gurus,

Please show me to the right manual/discussion if my questions are already 
answered/solved.

1. DEBUG message level separation:

In v7.3 there were the annoying DEBUG messages Start/CloseTransactCommand.
In v7.4 you could eliminate them from user DEBUG messages by logging from
	DEBUG2 level.
In v8.0.0rc4, they are back at DEBUG2 level.

Is there a way to eliminate them AND keep user DEBUG messages (i.e. 
plpgsql's "RAISE DEBUG")


2. CONTEXTs and HINTs

Looked up all the lines in postgresql.conf, but couldn't find the one to 
turn CONTEXT and HINT lines after notices or errors. They proved to be very 
useful, but can't make them be logged in v8. Is there a way?


3. redirect_stderr bogus?

Activating redirect_stderr, setting log_dir, log_file and all the rotate 
params, it looked to me that all output the logger produced were 'db system 
ready' and 'shut down', and not even these lines appeared in the log file. 
May it be a bug, or simply the fact that a nonempty file already existed 
(from redirected stdout, as described above)<

TIA,
-- 
G.

Responses

pgsql-admin by date

Next:From: Bradley KieserDate: 2005-01-12 22:15:56
Subject: Setting search_path in JDBC (schema usage)
Previous:From: Kavan, Dan (IMS)Date: 2005-01-12 16:16:43
Subject: pam

pgsql-patches by date

Next:From: Reinhard MaxDate: 2005-01-12 17:20:14
Subject: Re: SUSE port (was [ANNOUNCE] PostgreSQL 8.0.0 Release
Previous:From: Reinhard MaxDate: 2005-01-12 16:29:34
Subject: Re: SUSE port (was [ANNOUNCE] PostgreSQL 8.0.0 Release

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group