Обсуждение: problems in connection
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
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
On Tue, 2003-05-06 at 19:36, Shankar K wrote: > [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. It is trying to connect to a database called "postgres" and you haven't got one. If you don't specify a database, psql tries to find one whose name is the same as your username. Try psql -d template1 -p 5433 -- Oliver Elphick Oliver.Elphick@lfix.co.uk Isle of Wight, UK http://www.lfix.co.uk/oliver GPG: 1024D/3E1D0C1C: CA12 09E0 E8D5 8870 5839 932A 614D 4C34 3E1D 0C1C ======================================== "If it is possible, as much as it depends on you, live peaceably with all men." Romans 12:18