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. -- Oliver Elphick [EMAIL PROTECTED] Isle of Wight http://www.lfix.co.uk/oliver GPG: 1024D/A54310EA 92C8 39E7 280E 3631 3F0E 1EC0 5664 7A2F A543 10EA ======================================== "Therefore being justified by faith, we have peace with God through our Lord Jesus Christ." Romans 5:1 ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html