| From: | P Kapat <kap4lin(at)gmail(dot)com> |
|---|---|
| To: | pgsql-novice(at)postgresql(dot)org |
| Subject: | correct config (and syntax) for remote access |
| Date: | 2009-03-15 04:19:25 |
| Message-ID: | daef5be80903142119i2b2c2f32v14b0b1c864ea3517@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Peter Jackson | 2009-03-15 09:10:06 | Re: correct config (and syntax) for remote access |
| Previous Message | Steve Crawford | 2009-03-12 16:14:35 | Re: Script Repository |