pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Omer Mustafa <omustafa@internode.com.au>
To: pgsql-admin@postgresql.org
Subject: Connection refused. Check that the hostname and port are correct
Date: Thu, 20 Jul 2006 16:48:39 +0930
Message-ID: <44BF2E4F.7090200@internode.com.au> (raw)

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



view thread (4+ messages)  latest in thread

Message-ID: <44BF2E4F.7090200@internode.com.au>
Permalink:  ../44BF2E4F.7090200@internode.com.au/
Also on:    postgresql.org/message-id/44BF2E4F.7090200@internode.com.au

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-admin@postgresql.org
  Cc: omustafa@internode.com.au
  Subject: Re: Connection refused. Check that the hostname and port are correct
  In-Reply-To: <44BF2E4F.7090200@internode.com.au>
  References: <44BF2E4F.7090200@internode.com.au>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox