SEO
vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
04-10-2008, 06:26 AM
| ||||
| ||||
 Re: Connection refused. Check that the hostname and port are correct 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 >      |
 |
« Re: Connection refused. Check that the hostname and port
|
Re: [SQL] PostgreSQL server terminated by signal 11 »
| Thread Tools | |
| Display Modes | |
Linear Mode
|
|
All times are GMT. The time now is 09:59 AM.
