SEO
vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
04-09-2008, 07:13 AM
| ||||
| ||||
 Re: postgres log file how do i "Use the syslog daemon to record your logs." thanks, regards Surabhi ________________________________ From: Richard Huxton [mailto:dev@archonet.com] Sent: Thu 12/1/2005 3:07 PM To: surabhi.ahuja Cc: pgsql-general@postgresql.org Subject: Re: [GENERAL] postgres log file *********************** Your mail has been scanned by InterScan VirusWall. ***********-*********** surabhi.ahuja wrote: > the postgreslog has permission - 777, so anyone is able to write in it. > that s why it is atleast showing > >> LOG: logger shutting down > > but i want more logging to be done ..how can it be done .. Oh - I thought the message was being echoed to STDERR. You'll still want to setup a directory to store the log-files in, otherwise they can't be rotated. Create /var/log/postgresql and make sure it's owned by the "postgres" user (or whoever the db runs as) and is only writable by that user. Anyway, as far as I can see, this message is only produced when there is no database process for the logger to read from (see file backend/postmaster/syslogger.c about line 360). This implies the system itself is shutting down. Are you still having problems with your custom startup script? Two things I'd consider: 1. Install from a package (8.1 should be available for most platforms now). 2. Use the syslog daemon to record your logs. -- Richard Huxton Archonet Ltd      |
|
04-09-2008, 07:13 AM
| ||||
| ||||
| Re: postgres log file surabhi.ahuja wrote: > how do i "Use the syslog daemon to record your logs." See Ch 17.7 of the manuals "Error reporting and logging". You'll want to set your log_destination to syslog and make sure syslog itself is set up to route LOCAL0 (or whatever facility you use if you change it). But - don't just do this because you're having problems with logging to files. Figure out *why* you are having the problems first and then decide if you want to switch. -- Richard Huxton Archonet Ltd ---------------------------(end of broadcast)--------------------------- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq |
Linear Mode
