From: | Richard Broersma Jr <rabroersma(at)yahoo(dot)com> |
---|---|
To: | John Oliver <joliver(at)john-oliver(dot)net>, pgsql-general(at)postgresql(dot)org |
Subject: | Re: Problems logging in |
Date: | 2006-04-24 20:23:15 |
Message-ID: | 20060424202315.13471.qmail@web31805.mail.mud.yahoo.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
> > 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(at)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.
From | Date | Subject | |
---|---|---|---|
Next Message | Karen Hill | 2006-04-24 20:54:57 | Re: Transactions, PostgreSQL and MS Access front end. |
Previous Message | Dany De Bontridder | 2006-04-24 20:15:41 | Re: Postgreql 8.0.3 temporary Table Strange behaviour |