Turning on/off the logfile 
Author Message
 Turning on/off the logfile

PostgreSQL spits out logging information to stdout and stderr which can
then be piped to a file to act as a "log file". Is there a way to get
PostgreSQL to enable/disable this output without restarting the server?
Currently I have to edit /etc/rc.d/init.d/postgresql to run postgresql
with >mylogfile or >/dev/null, and restart the server.

If there isn't an ability to do this, I think I'll whip up a little script
that will read stderr/stdin but listen to signals and turn the output on or
off.

Thanks.

Gerald.

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster



Sun, 23 Nov 2003 20:51:54 GMT
 Turning on/off the logfile

Quote:

> If there isn't an ability to do this, I think I'll whip up a little script
> that will read stderr/stdin but listen to signals and turn the output on or
> off.

I think you can't turn this on & off on the fly, but I uncovered a
little program the other day which might work (I haven't tried it
yet), called flog.  See <http://oss.ezic.com/>.

--
----
Andrew Sullivan                               87 Mowat Avenue
Liberty RMS                           Toronto, Ontario Canada

                                         +1 416 646 3306 x110

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command



Sun, 23 Nov 2003 21:57:57 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. Turn it off, turn it on

2. Turn column headings off programmatically

3. Turn off ODBC informational messages?

4. Autocommit On even when it′s turned off??????

5. Help! Turn Off Log

6. Turn warning message off in a store procedure

7. How do I Turn off Aggregate functions in my cube for selected rows/columns

8. Can Transaction log be turned off?

9. How do you turn off Prepare Stored Proc with MDAC 2.1 to SQL 7

10. How do I turn off error msgs?

11. Turn off logging?

12. Turning DTS Packaing logging ON/OFF


 
Powered by phpBB® Forum Software