Connection refused. Check that the hostname and port are correct

Поиск
Список
Период
Сортировка
От Omer Mustafa
Тема Connection refused. Check that the hostname and port are correct
Дата
Msg-id 44BF2E4F.7090200@internode.com.au
обсуждение исходный текст
Ответы Re: Connection refused. Check that the hostname and port  (Jeff Frost <jeff@frostconsultingllc.com>)
Re: Connection refused. Check that the hostname and port are correct  ("Shoaib Mir" <shoaibmir@gmail.com>)
Список pgsql-admin
Hi,

I am new to PostgreSQL. I am trying to connect to my PostgreSQL database
installed on Unix. I am getting the following error message,

***************************************************************************
An error occured while establishing the connection.
    Type: org.postgresql.util.PSQLException   Error Code: 0   SQL State:
08004
Message:
    Connection refused. Check that the hostname and port are correct and
that the postmaster is accepting TCP/IP connections.
Exception: java.net.ConnectException: Connection refused: connect
***************************************************************************

I have checked port number, user name, password and they are all
correct. I have also checked that the postmaster is also running.

*******************************
postgres 25398 25344   0 11:57:51 pts/2       0:00 psql syslog
postgres 25548 25546   0 16:01:35 pts/3       0:00
/usr/local/pgsql/bin/postmaster
postgres 25613 25580   0 16:43:01 pts/3       0:00 grep post
postgres 25344 25301   0 10:57:05 pts/2       0:00 -tcsh
postgres 25546     1   0 16:01:35 pts/3       0:00
/usr/local/pgsql/bin/postmaster
postgres 25550 25549   0 16:01:35 pts/3       0:00
/usr/local/pgsql/bin/postmaster
postgres 25549 25546   0 16:01:35 pts/3       0:00
/usr/local/pgsql/bin/postmaster
postgres 25580 25443   0 16:34:17 pts/3       0:00 -tcsh
*******************************

I have the following settings in my configuration file

******************
host    syslog      sysloguser  10.10.10.10/32        trust
host    syslog      sysloguser  192.168.0.0/32        trust
*****************

Please advice what am I doing wrong

--

Thanks and Regards
Omer Mustafa
Oracle Application DBA
omustafa@internode.com.au
Internode, Level 1, 132 Grenfell Street
ADELAIDE SA 5000
Ph:    08 8228 2379
Mobile # 0421 038839

В списке pgsql-admin по дате отправления:

Предыдущее
От: Michael Fuhr
Дата:
Сообщение: Re: create table problems
Следующее
От: Richard Chen
Дата:
Сообщение: How to specify alternative locations for postgresql.{key,crt} files?