Re: correct config (and syntax) for remote access

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

In response to

Browse pgsql-novice by date

  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