pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Andy Shellam <andy.shellam-lists@mailnetwork.co.uk>
To: Moritz Bayer <moritz.bayer@googlemail.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: pg_hba.conf & putty
Date: Tue, 06 Mar 2007 00:02:26 +0000
Message-ID: <45ECAF92.1000307@mailnetwork.co.uk> (raw)
In-Reply-To: <c244500b0703051530j7bc6aca3q6042b86c2e81b23e@mail.gmail.com>
References: <c244500b0703051530j7bc6aca3q6042b86c2e81b23e@mail.gmail.com>

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! 




view thread (6+ messages)  latest in thread

Message-ID: <45ECAF92.1000307@mailnetwork.co.uk>
Permalink:  ../45ECAF92.1000307@mailnetwork.co.uk/
Also on:    postgresql.org/message-id/45ECAF92.1000307@mailnetwork.co.uk

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-admin@postgresql.org
  Cc: andy.shellam-lists@mailnetwork.co.uk, moritz.bayer@googlemail.com
  Subject: Re: pg_hba.conf & putty
  In-Reply-To: <45ECAF92.1000307@mailnetwork.co.uk>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox