Re: Need Help Enabling Remote Connections - Mailing list pgsql-novice

From Wright, George
Subject Re: Need Help Enabling Remote Connections
Date
Msg-id 51548D6D5BEB57468163194A8C1A0E9802B8A768@MAGPTCPEXC02.na.mag-ias.net
Whole thread Raw
In response to Re: Need Help Enabling Remote Connections  (Jonathan Mast <jhmast.developer@gmail.com>)
List pgsql-novice

I was getting the same error on 8.3.5 on Suse – not sure if it applies.

 

I had to change a line in /etc/rc.d/postgresql (Note the –i before $OPTIONS)

 

pg_ctl start -s -w -p $H -D $DATADIR -o "\" $OPTIONS\""

 

to

 

pg_ctl start -s -w -p $H -D $DATADIR -o "\" -i $OPTIONS\""

 

 


From: pgsql-novice-owner@postgresql.org [mailto:pgsql-novice-owner@postgresql.org] On Behalf Of Jonathan Mast
Sent: Wednesday, March 31, 2010 3:32 PM
To: pgsql-novice@postgresql.org
Subject: Re: [NOVICE] Need Help Enabling Remote Connections

 

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@gmail.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.developer@gmail.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?

 

 

pgsql-novice by date:

Previous
From: Konstantin Kuzvesov
Date:
Subject: libpq binary composite
Next
From: "Wright, George"
Date:
Subject: Re: Need Help Enabling Remote Connections