Re: And what about that Debugfile? - Mailing list pgsql-hackers

From Tom Lane
Subject Re: And what about that Debugfile?
Date
Msg-id 5723.991862721@sss.pgh.pa.us
Whole thread Raw
In response to And what about that Debugfile?  (Peter Eisentraut <peter_e@gmx.net>)
List pgsql-hackers
Peter Eisentraut <peter_e@gmx.net> writes:
> There is a "postgres" option -o which can redirect the server output to a
> file.  The postmaster output will still go to stderr.  Does anyone recall
> how this was supposed to be useful?

That code is, um, ancient.  I recall having seen comments to the effect
that you were expected to do something like "-o /dev/ttyNN" to redirect
the debug output of a particular backend to your console.  There's even
a field in the initial connection message to allow this to be specified
conveniently --- but I believe we've disabled it for security reasons,
since one doesn't really want random clients to be able to command the
backend to write on an arbitrary filename.

I can see some value in being able to separate the log output of one
backend from the rest of 'em ... but given the security issues, it seems
unlikely that anyone will ever again use the feature in the way it was
intended.  It needs to be rethunk.
        regards, tom lane


pgsql-hackers by date:

Previous
From: mlw
Date:
Subject: Re: REPLACE INTO table a la mySQL
Next
From: Tom Lane
Date:
Subject: Re: Idea: quicker abort after loss of client connection