Jon Theil Nielsen <jontheil@gmail.com> wrote:
> The server is started by a service script
> (/usr/local/etc/rc.d/postgresql start) and runs as the user
> "pgsql".
That would not explain why it started looking for user or database
"root".
> Uncommented content of postgresql.conf:
That includes some options which could probably be tuned to boost
performance, but those are not related to the current issue. Of
interest for the current problems:
> log_connections = on
> log_disconnections = on
With those turned on, there should be more lines of interest in the
cluster's log. Reviewing the log is your best bet.
--
Kevin Grittner
EDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company
