pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Connection refused. Check that the hostname and port are correct
4+ messages / 3 participants
[nested] [flat]

* Connection refused. Check that the hostname and port are correct
@ 2006-07-20 07:18 Omer Mustafa <omustafa@internode.com.au>
  2006-07-27 06:53 ` Re: Connection refused. Check that the hostname and port Jeff Frost <jeff@frostconsultingllc.com>
  2006-07-27 08:23 ` Re: Connection refused. Check that the hostname and port are correct Shoaib Mir <shoaibmir@gmail.com>
  0 siblings, 2 replies; 4+ messages in thread

From: Omer Mustafa @ 2006-07-20 07:18 UTC (permalink / raw)
  To: 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



^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* Re: Connection refused. Check that the hostname and port
  2006-07-20 07:18 Connection refused. Check that the hostname and port are correct Omer Mustafa <omustafa@internode.com.au>
@ 2006-07-27 06:53 ` Jeff Frost <jeff@frostconsultingllc.com>
  2006-07-27 07:05   ` Re: Connection refused. Check that the hostname and port Jeff Frost <jeff@frostconsultingllc.com>
  1 sibling, 1 reply; 4+ messages in thread

From: Jeff Frost @ 2006-07-27 06:53 UTC (permalink / raw)
  To: Omer Mustafa <omustafa@internode.com.au>; +Cc: pgsql-admin

On Thu, 20 Jul 2006, Omer Mustafa wrote:

>   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.

Most likely the postgresql server is set to listen for unix socket connections 
and/or connections from localhost only.  Look for the following in your 
postgresql.conf file:

#listen_addresses = 'localhost' # what IP interface(s) to listen on;
                                 # defaults to localhost, '*' = any

You most likely want to change that to:

listen_addresses = '*'

That's from an 8.x config file.  If you have an older version the terminology 
is likely different, but the effect is similar.

-- 
Jeff Frost, Owner 	<jeff@frostconsultingllc.com>
Frost Consulting, LLC 	http://www.frostconsultingllc.com/
Phone: 650-780-7908	FAX: 650-649-1954



^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* Re: Connection refused. Check that the hostname and port
  2006-07-20 07:18 Connection refused. Check that the hostname and port are correct Omer Mustafa <omustafa@internode.com.au>
  2006-07-27 06:53 ` Re: Connection refused. Check that the hostname and port Jeff Frost <jeff@frostconsultingllc.com>
@ 2006-07-27 07:05   ` Jeff Frost <jeff@frostconsultingllc.com>
  0 siblings, 0 replies; 4+ messages in thread

From: Jeff Frost @ 2006-07-27 07:05 UTC (permalink / raw)
  To: Omer Mustafa <omustafa@internode.com.au>; +Cc: pgsql-admin

Please do not remove the list from the Cc when replying.

On Thu, 27 Jul 2006, Omer Mustafa wrote:

> FATAL: no pg_hba.conf entry for host "203.26.95.33", user "sysloguser", 
> database "syslog"
>
> but i have this entry in my pg_hba file.

Most likely it is because you didn't reload the postgresql service after 
making the changes or because it is matching another entry first.  The 
pg_hba.conf is parsed in a top down manner with the first match winning. 
Post your pg_hba.conf and we can likely help you.  Remember that you must 
reload the postgresql service after making changes.


>
> Jeff Frost wrote:
>> On Thu, 20 Jul 2006, Omer Mustafa wrote:
>>
>>>   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.
>> 
>> Most likely the postgresql server is set to listen for unix socket 
>> connections and/or connections from localhost only.  Look for the following 
>> in your postgresql.conf file:
>> 
>> #listen_addresses = 'localhost' # what IP interface(s) to listen on;
>>                                 # defaults to localhost, '*' = any
>> 
>> You most likely want to change that to:
>> 
>> listen_addresses = '*'
>> 
>> That's from an 8.x config file.  If you have an older version the 
>> terminology is likely different, but the effect is similar.
>> 
>
>

-- 
Jeff Frost, Owner 	<jeff@frostconsultingllc.com>
Frost Consulting, LLC 	http://www.frostconsultingllc.com/
Phone: 650-780-7908	FAX: 650-649-1954



^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* Re: Connection refused. Check that the hostname and port are correct
  2006-07-20 07:18 Connection refused. Check that the hostname and port are correct Omer Mustafa <omustafa@internode.com.au>
@ 2006-07-27 08:23 ` Shoaib Mir <shoaibmir@gmail.com>
  1 sibling, 0 replies; 4+ messages in thread

From: Shoaib Mir @ 2006-07-27 08:23 UTC (permalink / raw)
  To: pgsql-admin

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
>

^ permalink  raw  reply  [nested|flat] 4+ messages in thread


end of thread, other threads:[~2006-07-27 08:23 UTC | newest]

Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2006-07-20 07:18 Connection refused. Check that the hostname and port are correct Omer Mustafa <omustafa@internode.com.au>
2006-07-27 06:53 ` Re: Connection refused. Check that the hostname and port Jeff Frost <jeff@frostconsultingllc.com>
2006-07-27 07:05   ` Re: Connection refused. Check that the hostname and port Jeff Frost <jeff@frostconsultingllc.com>
2006-07-27 08:23 ` Shoaib Mir <shoaibmir@gmail.com>

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