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 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 ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster      |
Linear Mode
