Skip site navigation (1) Skip section navigation (2)

Re: pgsql on debian

From: daniel <daniel(at)littlesaigon(dot)homedns(dot)org>
To: pgsql general <pgsql-general(at)postgresql(dot)org>
Subject: Re: pgsql on debian
Date: 2004-06-27 20:34:23
Message-ID: 40DF2F4F.2060505@littlesaigon.homedns.org (view raw or flat)
Thread:
Lists: pgsql-general
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



In response to

pgsql-general by date

Next:From: Tom LaneDate: 2004-06-27 22:11:19
Subject: Re: pgsql on debian
Previous:From: Ben-Nes MichaelDate: 2004-06-27 20:00:57
Subject: Re: Is this a "Stupid Question" ?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group