Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-admin by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group