Re: pg_hba.conf & putty

From: Andy Shellam <andy(dot)shellam-lists(at)mailnetwork(dot)co(dot)uk>
To: Moritz Bayer <moritz(dot)bayer(at)googlemail(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: pg_hba.conf & putty
Date: 2007-03-06 00:02:26
Message-ID: 45ECAF92.1000307@mailnetwork.co.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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!

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Phillip Smith 2007-03-06 00:17:36 Re: pg_hba.conf & putty
Previous Message Moritz Bayer 2007-03-05 23:57:31 Re: pg_hba.conf & putty