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@lfix.co.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