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:brick...@gmail.com] Sent: Wednesday, January 05, 2011 10:32 AM To: Little, Douglas Cc: pgsql-admin@postgresql.org Subject: Re: [ADMIN] unknown log messages On Wed, Jan 5, 2011 at 7:16 AM, Little, Douglas <douglas.lit...@orbitz.com<mailto:douglas.lit...@orbitz.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/>
