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

Re: Need Help Enabling Remote Connections

From: "Wright, George" <george(dot)wright(at)mag-ias(dot)com>
To: "Jonathan Mast" <jhmast(dot)developer(at)gmail(dot)com>,<pgsql-novice(at)postgresql(dot)org>
Subject: Re: Need Help Enabling Remote Connections
Date: 2010-03-31 20:31:56
Message-ID: 51548D6D5BEB57468163194A8C1A0E9802B8A769@MAGPTCPEXC02.na.mag-ias.net (view raw or flat)
Thread:
Lists: pgsql-novice
It's a passthrough to the postgres command itself.

 

From the doc:

 

-i 

Allows remote clients to connect via TCP/IP (Internet domain)
connections. Without this option, only local connections are accepted.
This option is equivalent to setting listen_addresses to * in
postgresql.conf or via -h. 

This option is deprecated since it does not allow access to the full
functionality of listen_addresses
<http://www.postgresql.org/docs/8.3/static/runtime-config-connection.htm
l#GUC-LISTEN-ADDRESSES> . It's usually better to set listen_addresses
directly. 

 

 

________________________________

From: pgsql-novice-owner(at)postgresql(dot)org
[mailto:pgsql-novice-owner(at)postgresql(dot)org] On Behalf Of Jonathan Mast
Sent: Wednesday, March 31, 2010 4:16 PM
To: pgsql-novice(at)postgresql(dot)org
Subject: Re: [NOVICE] Need Help Enabling Remote Connections

 

The equivalent file on CentOS uses this:

$SU -l postgres -c "$PGENGINE/initdb --pgdata='$PGDATA' --auth='ident
sameuser'" >> "$PGLOG" 2>&1 < /dev/null
 
I placed the -i option right before the -c option and it wouldn't start
at all.

What is the -i option supposed to be doing?

On Wed, Mar 31, 2010 at 4:02 PM, Wright, George
<george(dot)wright(at)mag-ias(dot)com> wrote:

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(at)postgresql(dot)org
[mailto:pgsql-novice-owner(at)postgresql(dot)org] On Behalf Of Jonathan Mast
Sent: Wednesday, March 31, 2010 3:32 PM
To: pgsql-novice(at)postgresql(dot)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(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

Responses

pgsql-novice by date

Next:From: Jonathan MastDate: 2010-03-31 20:34:06
Subject: Fwd: Need Help Enabling Remote Connections
Previous:From: Jonathan MastDate: 2010-03-31 20:15:33
Subject: Re: Need Help Enabling Remote Connections

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