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@xxxxxxxxxxxxxxxxxxxxxx>
Frost Consulting, LLC http://www.frostconsultingllc.com/
Phone: 650-780-7908 FAX: 650-649-1954
