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
