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