correct config (and syntax) for remote access - Mailing list pgsql-novice

From P Kapat
Subject correct config (and syntax) for remote access
Date
Msg-id daef5be80903142119i2b2c2f32v14b0b1c864ea3517@mail.gmail.com
Whole thread Raw
Responses Re: correct config (and syntax) for remote access  (Peter Jackson <mltasmaniac@tasjackson.com>)
Re: correct config (and syntax) for remote access  (Bob McConnell <rmcconne@lightlink.com>)
List pgsql-novice
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.

--
Regards
PK
--------------------------------------
http://counter.li.org  #402424

pgsql-novice by date:

Previous
From: Steve Crawford
Date:
Subject: Re: Script Repository
Next
From: Peter Jackson
Date:
Subject: Re: correct config (and syntax) for remote access