pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Shoaib Mir <shoaibmir@gmail.com>
To: pgsql-admin@postgresql.org
Subject: Re: Connection refused. Check that the hostname and port are correct
Date: Thu, 27 Jul 2006 13:23:52 +0500
Message-ID: <bf54be870607270123h5cbb3959pb67d8a29486fe54@mail.gmail.com> (raw)
In-Reply-To: <44BF2E4F.7090200@internode.com.au>
References: <44BF2E4F.7090200@internode.com.au>

That appears to be the JDBC driver is not able to connect to the PostgreSQL
database.

Try out the following:

- See if there is any firewall running, run 'iptables -F" on the database
server machine to disable it for a while and then test the same Java code
- Check the routing tables info and see if there is anything missing there.
- If the above two are okay and still its not connecting try out settng the
following in your pg_hba.conf file:

host    all         all         127.0.0.1/32          trust
host    all         all         0.0.0.0/0         trust

and then do a 'pg_ctl reload' and see if that now lets you connect through
the JDBC driver or not locally and over the lan.

Thanks,

-- 
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)

On 7/20/06, Omer Mustafa <omustafa@internode.com.au> wrote:
>
> 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
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: don't forget to increase your free space map settings
>

view thread (4+ messages)

Message-ID: <bf54be870607270123h5cbb3959pb67d8a29486fe54@mail.gmail.com>
Permalink:  ../bf54be870607270123h5cbb3959pb67d8a29486fe54@mail.gmail.com/
Also on:    postgresql.org/message-id/bf54be870607270123h5cbb3959pb67d8a29486fe54@mail.gmail.com

 · 

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: shoaibmir@gmail.com
  Subject: Re: Connection refused. Check that the hostname and port are correct
  In-Reply-To: <bf54be870607270123h5cbb3959pb67d8a29486fe54@mail.gmail.com>
  References: <44BF2E4F.7090200@internode.com.au> <bf54be870607270123h5cbb3959pb67d8a29486fe54@mail.gmail.com>

* 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