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

Jayadevan M <maymala.jayadevan@gmail.com> wrote:

> You have lines in the output which say

> "Sep 17 17:39:43 <local5.info> mflserver4 postgres[21022]: [39-1] LOG:  connection authorized: user=root
database=root"
> In case you are not doing it manually, do you have some cron job
> that is expected to backup the database or vacuum the database,
> and it is trying to connect to the database as root user, to
> database root?

... keeping in mind that many utilities will default user ID and
database name to the OS user if not specified on the command line.

Also, pg_ctl will attempt to connect to the database on a start or
restart to confirm that it is running.

--
Kevin Grittner
EDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company