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