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
