Re: libpq and PostgreSQL NOTICEs

From: "Tim Barnard" <tbarnard(at)povn(dot)com>
To: "Andrew Sullivan" <andrew(at)libertyrms(dot)com>
Cc: <pgsql-general(at)postgresql(dot)org>
Subject: Re: libpq and PostgreSQL NOTICEs
Date: 2001-06-04 18:29:42
Message-ID: 00f801c0ed24$5622ca20$a519af3f@hartcomm.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hmm, well it is, or appears to be. Here's how postmaster starts:

su - cvms -c "(/usr/local/pgsql/bin/postmaster -D/progs/db -B 256
2>&1 | logger -p local5.notice) &" > /dev/null 2>&1 &

Problem is, NOTICE's still goes to the console.
Any other ideas? This is really driving me bonkers!?!?! :-)

Tim

----- Original Message -----
From: "Andrew Sullivan" <andrew(at)libertyrms(dot)com>
To: "Tim Barnard" <tbarnard(at)povn(dot)com>
Sent: Monday, June 04, 2001 11:23 AM
Subject: Re: [GENERAL] libpq and PostgreSQL NOTICEs

> On Mon, Jun 04, 2001 at 10:59:14AM -0700, Tim Barnard wrote:
> > rather than spewing across the screen. Does anyone know if and how
> > to instruct Postgre to send its NOTICEs to a log file?
>
> Sure. When starting postgres, send its output to a file:
>
> postmaster [stuff] > /some/log 2>&1 &
>
> That's if you're using a Bourne-style shell.
>
> A
>
> --
> ----
> Andrew Sullivan 87 Mowat Avenue
> Liberty RMS Toronto, Ontario Canada
> <andrew(at)libertyrms(dot)com> M6K 3E3
> +1 416 646 3306 x110
>
>

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Jim Mercer 2001-06-04 19:12:24 Re: template1, can there be a template2/3/4?
Previous Message Tom Lane 2001-06-04 18:16:35 Re: template1, can there be a template2/3/4?