Re: unknown log messages

From: bricklen <bricklen(at)gmail(dot)com>
To: "Little, Douglas" <DOUGLAS(dot)LITTLE(at)orbitz(dot)com>
Cc: admin <pgsql-admin(at)postgresql(dot)org>, Scott Ribe <scott_ribe(at)elevated-dev(dot)com>
Subject: Re: unknown log messages
Date: 2011-01-05 17:26:05
Message-ID: AANLkTikX2Gog6k6i1RG3m7E=g+pGDJvZzJe+oNouMDj-@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On Wed, Jan 5, 2011 at 9:15 AM, Scott Ribe <scott_ribe(at)elevated-dev(dot)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 connect to 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.

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Alejandro Brust at federacion 2011-01-07 19:06:56 saludos y consulta
Previous Message Scott Ribe 2011-01-05 17:15:00 Re: unknown log messages