Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-novice by date

Next:From: Bob McConnellDate: 2009-03-15 13:08:44
Subject: Re: correct config (and syntax) for remote access
Previous:From: P KapatDate: 2009-03-15 04:19:25
Subject: correct config (and syntax) for remote access

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group