pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedLog stdout in PG 8?
4+ messages / 3 participants
[nested] [flat]
* Log stdout in PG 8?
@ 2005-08-12 20:23 Steve Lane <slane@soliantconsulting.com>
2005-08-12 20:39 ` Re: Log stdout in PG 8? Alvaro Herrera <alvherre@alvh.no-ip.org>
0 siblings, 1 reply; 4+ messages in thread
From: Steve Lane @ 2005-08-12 20:23 UTC (permalink / raw)
To: pgsql-admin
Hello all:
I am working with the new log redirection and rotation possibilities in
postgres 8.0.3. Here is my question.
I'm using redirect_stderr=true in my conf file. This works as I expect --
but I still seem to see some log messages trickle through to the console. I
assume these are appearing on stdout?
Formerly, I would always redirect stdout and stderr to the same logfile. I
tried that here, starting postmaster with 1>&2 (instead of 2>&1 as I used
to) but it doesn't seem to help.
Am I barking up the wrong tree?
-- sgl
--------
Steve Lane
Vice President
Soliant Consulting, Inc.
(610) 788-2124 (V)
(847) 890-6029 (F)
slane@soliantconsulting.com
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Log stdout in PG 8?
2005-08-12 20:23 Log stdout in PG 8? Steve Lane <slane@soliantconsulting.com>
@ 2005-08-12 20:39 ` Alvaro Herrera <alvherre@alvh.no-ip.org>
2005-08-12 22:52 ` Re: Log stdout in PG 8? Steve Lane <slane@soliantconsulting.com>
0 siblings, 1 reply; 4+ messages in thread
From: Alvaro Herrera @ 2005-08-12 20:39 UTC (permalink / raw)
To: Steve Lane <slane@soliantconsulting.com>; +Cc: pgsql-admin
On Fri, Aug 12, 2005 at 04:23:01PM -0400, Steve Lane wrote:
> Hello all:
>
> I am working with the new log redirection and rotation possibilities in
> postgres 8.0.3. Here is my question.
>
> I'm using redirect_stderr=true in my conf file. This works as I expect --
> but I still seem to see some log messages trickle through to the console. I
> assume these are appearing on stdout?
What messages?
--
Alvaro Herrera (<alvherre[a]alvh.no-ip.org>)
Oh, oh, las chicas galacianas, lo harán por las perlas,
¡Y las de Arrakis por el agua! Pero si buscas damas
Que se consuman como llamas, ¡Prueba una hija de Caladan! (Gurney Halleck)
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Log stdout in PG 8?
2005-08-12 20:23 Log stdout in PG 8? Steve Lane <slane@soliantconsulting.com>
2005-08-12 20:39 ` Re: Log stdout in PG 8? Alvaro Herrera <alvherre@alvh.no-ip.org>
@ 2005-08-12 22:52 ` Steve Lane <slane@soliantconsulting.com>
2005-08-13 19:10 ` Re: Log stdout in PG 8? Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 1 reply; 4+ messages in thread
From: Steve Lane @ 2005-08-12 22:52 UTC (permalink / raw)
To: Alvaro Herrera <alvherre@alvh.no-ip.org>; +Cc: pgsql-admin
Here's an example:
2005-08-12 15:12:43 CDT 12465 LOG: XX000: could not create IPv6 socket:
Address family not supported by protocol
2005-08-12 15:12:43 CDT 12465 LOCATION: StreamServerPort, pqcomm.c:337
These semm to be appearing in the written logs as well.
-- steve
> From: Alvaro Herrera <alvherre@alvh.no-ip.org>
> Date: Fri, 12 Aug 2005 16:39:35 -0400
> To: Steve Lane <slane@soliantconsulting.com>
> Cc: <pgsql-admin@postgresql.org>
> Subject: Re: [ADMIN] Log stdout in PG 8?
>
> On Fri, Aug 12, 2005 at 04:23:01PM -0400, Steve Lane wrote:
>> Hello all:
>>
>> I am working with the new log redirection and rotation possibilities in
>> postgres 8.0.3. Here is my question.
>>
>> I'm using redirect_stderr=true in my conf file. This works as I expect --
>> but I still seem to see some log messages trickle through to the console. I
>> assume these are appearing on stdout?
>
> What messages?
>
> --
> Alvaro Herrera (<alvherre[a]alvh.no-ip.org>)
> Oh, oh, las chicas galacianas, lo harán por las perlas,
> ¡Y las de Arrakis por el agua! Pero si buscas damas
> Que se consuman como llamas, ¡Prueba una hija de Caladan! (Gurney Halleck)
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Log stdout in PG 8?
2005-08-12 20:23 Log stdout in PG 8? Steve Lane <slane@soliantconsulting.com>
2005-08-12 20:39 ` Re: Log stdout in PG 8? Alvaro Herrera <alvherre@alvh.no-ip.org>
2005-08-12 22:52 ` Re: Log stdout in PG 8? Steve Lane <slane@soliantconsulting.com>
@ 2005-08-13 19:10 ` Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 0 replies; 4+ messages in thread
From: Tom Lane @ 2005-08-13 19:10 UTC (permalink / raw)
To: Steve Lane <slane@soliantconsulting.com>; +Cc: Alvaro Herrera <alvherre@alvh.no-ip.org>; pgsql-admin
Steve Lane <slane@soliantconsulting.com> writes:
> Here's an example:
> 2005-08-12 15:12:43 CDT 12465 LOG: XX000: could not create IPv6 socket:
> Address family not supported by protocol
> 2005-08-12 15:12:43 CDT 12465 LOCATION: StreamServerPort, pqcomm.c:337
> These semm to be appearing in the written logs as well.
There is not anything in the backend that would send that to stdout as
opposed to stderr.
What do you mean by "written logs" exactly?
What have you got log_destination set to?
regards, tom lane
^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2005-08-13 19:10 UTC | newest]
Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2005-08-12 20:23 Log stdout in PG 8? Steve Lane <slane@soliantconsulting.com>
2005-08-12 20:39 ` Alvaro Herrera <alvherre@alvh.no-ip.org>
2005-08-12 22:52 ` Steve Lane <slane@soliantconsulting.com>
2005-08-13 19:10 ` Tom Lane <tgl@sss.pgh.pa.us>
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