From: | Kevin Grittner <kgrittn(at)ymail(dot)com> |
---|---|
To: | Jayadevan M <maymala(dot)jayadevan(at)gmail(dot)com>, Jon Theil Nielsen <jontheil(at)gmail(dot)com> |
Cc: | "pgsql-novice(at)postgresql(dot)org" <pgsql-novice(at)postgresql(dot)org> |
Subject: | Re: Several problems with installation on FreeBSD - how to reinstall without loosing data |
Date: | 2013-09-18 08:55:31 |
Message-ID: | 1379494531.59344.YahooMailNeo@web162906.mail.bf1.yahoo.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
Jayadevan M <maymala(dot)jayadevan(at)gmail(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | Jon Theil Nielsen | 2013-09-18 09:12:25 | Re: Several problems with installation on FreeBSD - how to reinstall without loosing data |
Previous Message | Jayadevan M | 2013-09-18 03:31:10 | Re: Several problems with installation on FreeBSD - how to reinstall without loosing data |