Re: pgsql on debian

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 olly(at)lfix(dot)co(dot)uk
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