problems in connection
От | Shankar K |
---|---|
Тема | problems in connection |
Дата | |
Msg-id | 20030506183611.33812.qmail@web21106.mail.yahoo.com обсуждение исходный текст |
Ответы |
Re: problems in connection
Re: problems in connection |
Список | pgsql-admin |
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
В списке pgsql-admin по дате отправления: