Re: supressing NOTICE messages on Windows/cygwin only not working?

Thanks Tom,

Embarassingly correct guesses.  Thanks for the quick response.


On Tue, 07 Sep 2004 11:29:17 -0400, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> Alex Soto <apsoto@gmail.com> writes:
> > I'm noticing NOTICE messages can't be turned off with my cygwin-based
> > platform.   I've had other's confirm it works on linux.
>
> The SET will definitely turn off messages that the backend thinks it is
> delivering to the client.  However, it won't turn off logging of those
> same messages in the postmaster log --- which may just be standard
> error.  Allow me to guess a couple things:
>
> 1. You originally launched the postmaster from the same terminal window
> you are now running psql in, and you didn't do anything to redirect its
> error log to a file or /dev/null or syslog or whatever.
>
> 2. Before you changed client_min_messages you were actually seeing *two*
> copies of these messages, one sent through psql and one popping up
> because you are reading the postmaster's stderr.
>
> While you could make this go away by changing log_min_messages, a better
> idea would be to redirect postmaster stderr someplace when you start it.
>
>                         regards, tom lane
>