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
---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
