1)from root su postgres
2)createuser the username
3)exit
4)su the user
5)createdb
psql the database
Jay wrote:
> 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.
>>
>>
>>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster