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

correct config (and syntax) for remote access

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: (view raw, whole thread or download thread mbox)
Lists: pgsql-novice
Host A (IP : has the 8.1.11 postgress server running. I want
to set it up so that I can connect from Host B (IP

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          md5
host    all         foouser       md5

Relevant lines form /var/lib/pgsql/data/postgresql.conf (on host A):
listen_addresses = 'localhost,'

Will this work? The firewall has 5432 port open for connection between A and B.

--------------------------------------  #402424


pgsql-novice by date

Next:From: Peter JacksonDate: 2009-03-15 09:10:06
Subject: Re: correct config (and syntax) for remote access
Previous:From: Steve CrawfordDate: 2009-03-12 16:14:35
Subject: Re: Script Repository

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