The following bug has been logged online: Bug reference: 2088 Logged by: Dick Snippe Email address: [EMAIL PROTECTED] PostgreSQL version: 8.1.0 Operating system: Fedora Core 2 Description: logfiles only readable by instance owner Details:
when redirect_stderr = true the logfiles created by log_filename are only readable by the postgres instance owner. I assume this is caused by umask((mode_t) 0077) on line 414 in scr/backend/postmaster/postmaster.c setting umask 077 makes sense for the data files, but not per se for the logfile. It would be nice if the logfile mode was configurable, or defaulted to 644 or 640. A similar scheme to setting the permissions on unix_socket_directory could perhaps be used. ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings