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:15:33 |
Message-ID: | x2wf5af14001003311315ye629bd8o921d5c94fd7b7178@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
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?
>
>
>
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Wright, George | 2010-03-31 20:31:56 | Re: Need Help Enabling Remote Connections |
Previous Message | Wright, George | 2010-03-31 20:02:02 | Re: Need Help Enabling Remote Connections |