| From: | Omer Mustafa <omustafa(at)internode(dot)com(dot)au> |
|---|---|
| To: | pgsql-admin(at)postgresql(dot)org |
| Subject: | Connection refused. Check that the hostname and port are correct |
| Date: | 2006-07-20 07:18:39 |
| Message-ID: | 44BF2E4F.7090200@internode.com.au |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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(at)internode(dot)com(dot)au
Internode, Level 1, 132 Grenfell Street
ADELAIDE SA 5000
Ph: 08 8228 2379
Mobile # 0421 038839
| From | Date | Subject | |
|---|---|---|---|
| Next Message | LiveShell | 2006-07-20 09:26:51 | biginteger to timestamp |
| Previous Message | Ghislain Bob Hachey | 2006-07-20 03:48:11 | Re: Insert NULL value with to_numeric() |