Re: pgsql on debian

hi oliver
i tried the following command but nothing seems to work
psql -U root -d root
psql: FATAL:  IDENT authentication failed for user "root"

 any suggestions
thanks
jay

Oliver Elphick wrote:

>On Sun, 2004-06-27 at 00:36, Jay wrote:
>
>
>>Hi group,
>>I am trying to get pgsql working on my debian system. I installed pgsql
>>using apt-get. but then i cant connect to it . i am using the following
>>command
>> psql -U jay -d jaydb
>>
>> earlier i used create su postgres 'createdb root' jaydb.
>>
>>
>
>Sounds as if you created a database called 'root'.
>
>
>
>> but now i cannot access the db.
>>i get the follwing msgs
>>
>>psql: FATAL:  database "jaydb" does not exist
>>
>>
>
>Use "psql -l" to list existing databases.
>
>
>