Re: Several problems with installation on FreeBSD - how to reinstall without loosing data

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