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

Re: Need Help Enabling Remote Connections

From: Luiz Eduardo Cantanhede Neri <lecneri(at)gmail(dot)com>
To: Jonathan Mast <jhmast(dot)developer(at)gmail(dot)com>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: Need Help Enabling Remote Connections
Date: 2010-03-31 19:50:00
Message-ID: x2j252e1f291003311250w277d673z16e002a88c4fba2a@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-novice
Hm... I didnt notice that u had put ur pg_hba.conf there so I thought u
might had only localhost allowed to connect to ur database.

On Wed, Mar 31, 2010 at 4:31 PM, Jonathan Mast
<jhmast(dot)developer(at)gmail(dot)com>wrote:

> Thanks, but I'm not seeing anything new on the link.
>
> here is my pg_hba.conf file:
> host    all         all         192.168.1.0/24          trust
> host    all         all         192.168.15.0/24          trust
>
> I don't understand why this isn't working.
>
>
>
> On Wed, Mar 31, 2010 at 3:14 PM, Luiz Eduardo Cantanhede Neri <
> lecneri(at)gmail(dot)com> wrote:
>
>> http://www.postgresql.org/docs/8.2/interactive/auth-pg-hba-conf.html
>>
>>
>>
>> On Wed, Mar 31, 2010 at 4:09 PM, Jonathan Mast <
>> jhmast(dot)developer(at)gmail(dot)com> wrote:
>>
>>> I've just installed Postgresql Server 8.1.xx on Cent OS 5.4, the server's
>>> IP is 192.168.15.113
>>>
>>> I added a db user (with super-user privileges) and edited pg_hba.conf to
>>> allow 192.168.15.0/24 and 192.168.1.0/24 (the remote subnet, where I'm
>>> trying to connect from).
>>>
>>> I edited postgresql.conf to:
>>> listen_addresses = '*'
>>> port = 5432
>>> max_connections = 100
>>>
>>> But I cannot connect remotely, I get "Server doesn't Listen" from
>>> pgAdmin.
>>>
>>> Any ideas?
>>>
>>
>>
>

In response to

pgsql-novice by date

Next:From: Wright, GeorgeDate: 2010-03-31 20:02:02
Subject: Re: Need Help Enabling Remote Connections
Previous:From: Jonathan MastDate: 2010-03-31 19:31:43
Subject: Re: Need Help Enabling Remote Connections

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