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

Re: correct config (and syntax) for remote access

From: Bob McConnell <rmcconne(at)lightlink(dot)com>
To: P Kapat <kap4lin(at)gmail(dot)com>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: correct config (and syntax) for remote access
Date: 2009-03-15 13:08:44
Message-ID: 49BCFDDC.6050401@lightlink.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.
> 

Not quite. The listen_addresses should be 'localhost,1.2.3.4'. localhost 
is 127.0.0.1, which can be reached by any process on that machine. The 
other address is the TCP/IP address for the interface you want postgres 
to receive connections on. It has to be an address on the same computer 
as your server. i.e. one that shows up when you run 'ifconfig' on that 
box. It is probably easier to just use '*' unless you have multiple 
network interfaces.

Don't forget to restart the server after you change those files.

Bob McConnell
N2SPP

In response to

Responses

pgsql-novice by date

Next:From: P KapatDate: 2009-03-16 18:40:28
Subject: Re: correct config (and syntax) for remote access
Previous:From: Peter JacksonDate: 2009-03-15 09:10:06
Subject: Re: correct config (and syntax) for remote access

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