Re: unknown log messages - Mailing list pgsql-admin

From bricklen
Subject Re: unknown log messages
Date
Msg-id AANLkTikX2Gog6k6i1RG3m7E=g+pGDJvZzJe+oNouMDj-@mail.gmail.com
Whole thread Raw
In response to Re: unknown log messages  (Scott Ribe <scott_ribe@elevated-dev.com>)
List pgsql-admin
On Wed, Jan 5, 2011 at 9:15 AM, Scott Ribe <scott_ribe@elevated-dev.com> wrote:
> On Jan 5, 2011, at 9:34 AM, Little, Douglas wrote:
>
>> No dbuser named Root.
>
> That's my point, you don't have a db user named root, but you do (maybe) have a process running as root trying to
connectto the db. 
>
>> So it sounds like the log messages are standard for a login attempt with unknown user.
>
> No, they are standard for root trying to connect to the database when you do not have a db user named root.


As Scott says, check your root crontab for any scripts that might
connect to the db, and check the connection string. The "[local]" part
means that the call is being initiated locally to that box, else it
would should the IP.

pgsql-admin by date:

Previous
From: Scott Ribe
Date:
Subject: Re: unknown log messages
Next
From: ojas dubey
Date:
Subject: Re: Find all running postgres DB servers on a network