[GENERAL] postgres log file mode

2009-11-28 Thread Filip Rembiałkowski
Is it possible to force file mode of postgres log files, eg. as if it was changed by chmod 640 /log/file.log at present (I use 8.4.1) it is generated with mode 600. the goal is to let users in "postgtres" group to read these files. thanks in advance. -- Filip Rembiałkowski JID,mailto:filip.r

Re: [GENERAL] postgres log file

2005-12-01 Thread Richard Huxton
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

Re: [GENERAL] postgres log file

2005-12-01 Thread surabhi.ahuja
Title: Re: [GENERAL] postgres log file how do i  "Use the syslog daemon to record your logs."   thanks, regards Surabhi From: Richard Huxton [mailto:[EMAIL PROTECTED]Sent: Thu 12/1/2005 3:07 PMTo: surabhi.ahujaCc: pgsql-general@postgresql.orgSubject: Re: [GENERAL] postgre

Re: [GENERAL] postgres log file

2005-12-01 Thread Richard Huxton
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

Re: [GENERAL] postgres log file

2005-11-30 Thread surabhi.ahuja
Title: Re: [GENERAL] postgres log file  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 ..   thanks, regards Surabhi   From: Richard Hux

Re: [GENERAL] postgres log file

2005-11-29 Thread Richard Huxton
surabhi.ahuja wrote: hi I start postmaster by giving the following command /usr/bin/pg_ctl -w -l postgreslog -D $PGDATA -p /usr/bin/postmaster -o '-p ${PGPORT}' start however nothing gets looged in postgrelog. if i see postgreslog it shows me only this: LOG: logger shutting down LOG: l

[GENERAL] postgres log file

2005-11-29 Thread surabhi.ahuja
 hi I start postmaster by giving the following command   /usr/bin/pg_ctl -w -l postgreslog -D $PGDATA -p /usr/bin/postmaster -o '-p ${PGPORT}' start   however nothing gets looged in postgrelog.   if i see postgreslog it shows me only this: LOG:  logger shutting downLOG:  logger shutting downL