Re: unknown log messages

No dbuser named Root. Don’t know who is the client, so having trouble identifying it.
So it sounds like the log messages are standard for a login attempt with unknown user.

I have a case open with GP.

Thanks for the thoughts.
Doug

From: bricklen [mailto:bricklen(at)gmail(dot)com]
Sent: Wednesday, January 05, 2011 10:32 AM
To: Little, Douglas
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: [ADMIN] unknown log messages

On Wed, Jan 5, 2011 at 7:16 AM, Little, Douglas <DOUGLAS(dot)LITTLE(at)orbitz(dot)com<mailto:DOUGLAS(dot)LITTLE(at)orbitz(dot)com>> wrote:

Env: Greenplum 3.3.6(based on PG 8.2.13), Solaris 10u5, Sun X4540 (x86)
We are probing the machine with sitescope for cpu/mem/disk stats, but I don’t believe it’s connecting to the db.

2011-01-01 13:01:56.848368 CST,"root","root",p427,th1,"[local]",,2011-01-01 13:01:56 CST,0,,,seg-1,,,,,"FATAL","28000","no pg_hba.conf entry for host ""[local]"", user ""root"", database ""root"", SSL off",,,,,,,0,,"auth.c",369,"Traceback 0: a12ca6: /usr/local/greenplum-db-3.3.6.6/bin/postgres errstart+0x3e6

Do you actually have a database named "root" and a db user named "root"? If not, I'd check your client connection details to ensure you pass in the database name and user.
Also, if you have a support contract, you could contact Greenplum -- I've generally found them to be pretty responsive. Barring that, you could also try posting to http://community.greenplum.com<http://community.greenplum.com/>