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

Re: Need Help Enabling Remote Connections

From: Jonathan Mast <jhmast(dot)developer(at)gmail(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: Re: Need Help Enabling Remote Connections
Date: 2010-03-31 20:56:05
Message-ID: g2xf5af14001003311356u1f297bd2o9ff4af6285bc8812@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-novice
Ok, I got the -i option in there, still no dice.  What can i look at on the
server itself to see if I'm evening reaching postgre?


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

>  Even though I listed my exact ip/port in pg_hba.conf, I could not connect
> without the –i option in postgresql.
>
>
>
> It may be my OS and DB version, not sure.
>
>
>
>
>  ------------------------------
>
> *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:34 PM
>
> *To:* pgsql-novice(at)postgresql(dot)org
> *Subject:* Fwd: [NOVICE] Need Help Enabling Remote Connections
>
>
>
>
>
> ---------- Forwarded message ----------
> From: *Jonathan Mast* <jhmast(dot)developer(at)gmail(dot)com>
> Date: Wed, Mar 31, 2010 at 4:33 PM
> Subject: Re: [NOVICE] Need Help Enabling Remote Connections
> To: "Wright, George" <george(dot)wright(at)mag-ias(dot)com>
>
>
> So I set the listen_addresses to '*' so that means the -i option should be
> irrelevant, right?
>
> Thanks
>
>
>
> On Wed, Mar 31, 2010 at 4:31 PM, Wright, George <george(dot)wright(at)mag-ias(dot)com>
> wrote:
>
> 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.html#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

pgsql-novice by date

Next:From: Tom LaneDate: 2010-03-31 21:15:51
Subject: Re: Fwd: Need Help Enabling Remote Connections
Previous:From: Wright, GeorgeDate: 2010-03-31 20:37:35
Subject: Re: Need Help Enabling Remote Connections

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