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 по дате отправления:

Предыдущее
От: "Daniel Seichter"
Дата:
Сообщение: Re: pg_dumpall / pg_dump
Следующее
От: Shankar K
Дата:
Сообщение: Re: problems in connection