What address are you using for "server.ip.address"?
I believe this is the address you should put in your pg_hba.conf, not
127.0.0.1.
Then in PgAdmin, connect to localhost:5432.
You can always check your PostgreSQL logs and see what source address
the request is coming from.
Andy.
Moritz Bayer wrote:
dear list,
I know there are already hunderts of posts about pg_hba.conf, but
still after reading a few of them I still got troubles with this topic.
I've got a vpn server with a ststic ip address, java apps are
supposed to run there receiving data from a postgresql database.
The database is running, but for changes on it I want to open a putty
connection while using pgAdmin.
In putty, I define a tunnel to port 5432, its displayed like this:
Lserver.ip.address:5432
Thought this entries in my pg_hba.conf would do it:
# "local" is for Unix domain socket connections only
local all all md5
# IPv4 local connections:
host all all 127.0.0.1/32
<http://127.0.0.1/32> md5
# IPv6 local connections:
host all all ::1/128 md5
well, it doesn't. When i run pgAdmin with an open putty connection,
it still says: error connecting to server.
Any hints how I can find out whats still wrong?
Thanks in advance,
Mo
!DSPAM:37,45ecaa2b103007769414910!
