From: | Shankar K <shan0075(at)yahoo(dot)com> |
---|---|
To: | pgsql-admin(at)postgresql(dot)org |
Subject: | problems in connection |
Date: | 2003-05-06 18:36:11 |
Message-ID: | 20030506183611.33812.qmail@web21106.mail.yahoo.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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
From | Date | Subject | |
---|---|---|---|
Next Message | Shankar K | 2003-05-06 18:53:06 | Re: problems in connection |
Previous Message | Daniel Seichter | 2003-05-06 17:55:30 | Re: pg_dumpall / pg_dump |