> > redirect_stderr = true > > log_directory = 'pg_log' > > log_filename = 'postgresql-%Y-%m-%d_%H%M%S.log' > > log_rotation_size = 10240 > > log_min_messages = info > > log_line_prefix = '%t%%%d ' > > > > These are the setting in my conf file. > > [EMAIL PROTECTED] root]# tail /var/log/pgsqllog > FATAL: unrecognized configuration parameter "redirect_stderr" > FATAL: unrecognized configuration parameter "log_directory" > FATAL: unrecognized configuration parameter "log_filename" > FATAL: unrecognized configuration parameter "log_rotation_size" > FATAL: unrecognized configuration parameter "log_line_prefix" > > Looks like something else I tried got some form of logging working, but > you must have a very different version of postgresql than I do :-)
This is just a guess on my part, but I do not believe that PostgreSQL as rights to write logs to the /var/log directory. From my understanding PostgreSQL is a service that runs under the non-super-user postgres account. ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
