> > 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. > > [root@web1 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.
