[lug] pgsql through perl ?????

[P. Scott DeVos]

Avinash Dinesh wrote:
> hello people
> i recently installed pgsql on my system and logged in
> as root to enter into the default user "postgres"..

The default postgresql config requires you to *be* the user you log in 
as.  Try

$ su -
# su - postgres
$ psql <database name>


-- 
P. Scott DeVos
President,
Saving Tree Services, Inc.
dba Countryside Technology Center