Re: problems in connection

Please ignore..my fault

i should have used psql template1 -p 5433

thanks anyways.

--- Shankar K <shan0075@yahoo.com> wrote:
> hi,
>
> not sure what am missing here. i have 2 database
> clusters in a same machine running on different
> ports.
> each have a separate PGDATA dir.
>
> now if you do
>
> [postgres@ base]$ oid2name -p 5433
> All databases:
> ---------------------------------
> 1      = template1
> 16975  = template0
>
> -- this is from one of the db cluster running on
> 5433
> port. looks good.
>
> [postgres@ base]$ oid2name
> All databases:
> ---------------------------------
> 16981  = testdb
> 1      = template1
> 16975  = template0
>
> -- this is another db cluster running on 5432
> default
> port. look good too.
>
> [postgres@ base]$ psql -l
>          List of databases
>     Name    |  Owner   | Encoding
> ------------+----------+-----------
>  template0  | postgres | SQL_ASCII
>  template1  | postgres | SQL_ASCII
>  testdb     | postgres | SQL_ASCII
> (3 rows)
>
> [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.
>
> thanks,
> Shankar.
>
> __________________________________
> Do you Yahoo!?
> The New Yahoo! Search - Faster. Easier. Bingo.
> http://search.yahoo.com
>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to
> majordomo@postgresql.org
>


__________________________________
Do you Yahoo!?
The New Yahoo! Search - Faster. Easier. Bingo.
http://search.yahoo.com