Re: problems in connection

On Tue, 2003-05-06 at 19:36, Shankar K wrote:
> [postgres@ base]$ psql -l -p 5433
>         List of databases
>    Name    |  Owner   | Encoding
> -----------+----------+-----------
>  template0 | postgres | SQL_ASCII
>  template1 | postgres | SQL_ASCII
> (2 rows)
>
> but when i try to login to the database cluster thats
> listening on 5433, i end up with the error.
>
> [postgres@ base]$ psql -p 5433
> psql: FATAL:  Database "postgres" does not exist in
> the system catalog.
>
> any clues as to what am missing here.

It is trying to connect to a database called "postgres" and you haven't
got one.  If you don't specify a database, psql tries to find one whose
name is the same as your username.

Try

 psql -d template1 -p 5433

--
Oliver Elphick                                Oliver.Elphick@lfix.co.uk
Isle of Wight, UK                             http://www.lfix.co.uk/oliver
GPG: 1024D/3E1D0C1C: CA12 09E0 E8D5 8870 5839  932A 614D 4C34 3E1D 0C1C
                 ========================================
     "If it is possible, as much as it depends on you, live
      peaceably with all men."        Romans 12:18