Logging 
Author Message
 Logging
Hey,

I've set my pg_options file to write log messages, but it only logs to
/var/log/messages instead of /var/log/postgresql wich remains empty.

Why is that and how can i change it? Maybe it's a sylog question, but
beeing new to it and all i can't really figure things out.

I've installed the 7.0.3-1 rpm on an RedHat 6.2 system.

Thanks,
Anders,



Sat, 10 May 2003 03:01:41 GMT
 Logging

Quote:

> I've set my pg_options file to write log messages, but it only logs to
> /var/log/messages instead of /var/log/postgresql wich remains empty.
> Why is that and how can i change it? Maybe it's a sylog question, but
> beeing new to it and all i can't really figure things out.

You need to edit /etc/syslog.conf to direct the output of PostgreSQL to
the file you wish to hold the log.  The facility used by default in
7.0.3 is local0, so a line:
local0.*                /var/log/postgresql
will do what you expect.
--
Lamar Owen
WGCR Internet Radio
1 Peter 4:11


Sat, 10 May 2003 04:05:58 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. Log shipping: Auto restore transaction log?

2. Incomplete DTS log -- Some steps are not logged

3. 8gb log 8mb data why can't I get the log smaller

4. Move the log to another log

5. Logging of SQL messages on the NT event log

6. Logging into NT Error Log

7. Transaction Log Backups Are Slower When The First Portion Of The Log Sequence Number Increments

8. Trigger-based audit logging to properly log old/new NULL

9. SELECT INTO OR INSERT INTO, LOGGED AND NON-LOGGED

10. Message Logging into Package log file

11. Log backup shrinks my log file

12. Truncate log sends error to event log


 
Powered by phpBB® Forum Software