Re: Problems logging in

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.

In response to

Browse pgsql-general by date

  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