From: | Peter Jackson <mltasmaniac(at)tasjackson(dot)com> |
---|---|
To: | pgsql <pgsql-novice(at)postgresql(dot)org> |
Subject: | Re: correct config (and syntax) for remote access |
Date: | 2009-03-15 09:10:06 |
Message-ID: | 49BCC5EE.9010107@tasjackson.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
P Kapat wrote:
> Host A (IP : 1.2.3.4) has the 8.1.11 postgress server running. I want
> to set it up so that I can connect from Host B (IP 5.6.7.8).
>
> Relevant lines from /var/lib/pgsql/data/pg_hba.conf (on host A)
> local all postgres ident sameuser
> local all all ident sameuser
> host all all 127.0.0.1/32 md5
> host all foouser 5.6.7.8/32 md5
>
> Relevant lines form /var/lib/pgsql/data/postgresql.conf (on host A):
> listen_addresses = 'localhost,5.6.7.8'
>
> Will this work? The firewall has 5432 port open for connection between A and B.
>
I can definitely say the last line wont the listen addresses must be
the local one, so localhost 1.2.3.4
Peter Jackson
From | Date | Subject | |
---|---|---|---|
Next Message | Bob McConnell | 2009-03-15 13:08:44 | Re: correct config (and syntax) for remote access |
Previous Message | P Kapat | 2009-03-15 04:19:25 | correct config (and syntax) for remote access |