Re: Problem to connect from host via JDBC ... - Mailing list pgsql-jdbc

From Rouyre Frédéric
Subject Re: Problem to connect from host via JDBC ...
Date
Msg-id B3120923FCE6D411AF9300E0180439276B9FA8@oslxch01.osl.be
Whole thread Raw
In response to Problem to connect from host via JDBC ...  (<tsmets@brutele.be>)
List pgsql-jdbc
I dit not see that the postmaster was executed by pg_ctl so removing the -o
will NOT do the trick, indeed.

Make a simple test, try to load postgres with

su -l postgres '/usr/bin/postmaster -S -i'

If you are not able to connect the db (through socket) after this command,
then there is another problem, not linked with the way you are executing
pg_ctl.

Let me know the results...

> -----Original Message-----
> From: tsmets@brutele.be [mailto:tsmets@brutele.be]
> Sent: Tuesday, March 05, 2002 7:40 PM
> To: Rouyre Frédéric; 'pgsql jdbc'
> Subject: Re: [JDBC] Problem to connect from host via JDBC ...
>
>
>
>
> I tried to remove the -o but it was not successfull :-(
> I then tried to move the -i forward in the argument line but
> it was also a
> failure... :-(
> This is the command executed by the call to
>                 /etc/init.d/postgresql start
>
>                 su -l postgres -c '/usr/bin/pg_ctl  -D ${PGDATA} -p
> /usr/bin/postmaster -o -i start' >/dev/null 2>&1
>
> -->  Success
>     but any other solution, like :
>                 su -l postgres -c '/usr/bin/pg_ctl -i -D ${PGDATA} -p
> /usr/bin/postmaster -o start' >/dev/null 2>&1
>
> -->  Failed
>                 su -l postgres -c '/usr/bin/pg_ctl  -i -D ${PGDATA} -p
> /usr/bin/postmaster -o start' >/dev/null 2>&1
>
> -->  Failed
>                 su -l postgres -c '/usr/bin/pg_ctl -D ${PGDATA} -p
> /usr/bin/postmaster -i -o start' >/dev/null 2>&1
>                                                             --> Failed
>                 su -l postgres -c '/usr/bin/pg_ctl  -D ${PGDATA} -i -p
> /usr/bin/postmaster -o start' >/dev/null 2>&1
>
> -->  Failed
>
> Some has a wilde / wise guess for me ?
>
> Thomas,
>
> --
> Thomas SMETS
> rue J. Wytsmanstraat 62
> 1050 Bruxelles
> yahoo-id : smetsthomas
> ----- Original Message -----
> From: "Rouyre Frédéric" <Frederic.Rouyre@osl.be>
> To: "'pgsql jdbc'" <pgsql-jdbc@postgresql.org>
> Sent: 05 March, 2002 3:35 PM
> Subject: Re: [JDBC] Problem to connect from host via JDBC ...
>
>
> > I already answered but I forgot to put the list in cc ...
> > This is the -o that causes the problem ... indeed, -i is taken as a
> backend
> > parameter, not a postmaster parameter. Removing the -o
> should do the trick
> >
> >
> > > -----Original Message-----
> > > From: Dave Cramer [mailto:Dave@micro-automation.net]
> > > Sent: Tuesday, March 05, 2002 2:22 PM
> > > To: tsmets@brutele.be; 'pgsql jdbc'
> > > Subject: Re: [JDBC] Problem to connect from host via JDBC ...
> > >
> > >
> > > Thomas,
> > >
> > > Can you send me the results of netstat -nlp | grep 5432
> > >
> > > Dave
> > >
> > > -----Original Message-----
> > > From: pgsql-jdbc-owner@postgresql.org
> > > [mailto:pgsql-jdbc-owner@postgresql.org] On Behalf Of
> > > tsmets@brutele.be
> > > Sent: Tuesday, March 05, 2002 3:47 AM
> > > To: pgsql jdbc
> > > Subject: [JDBC] Problem to connect from host via JDBC ...
> > >
> > >
> > >
> > >
> > > I configured the postgres DB to start with :
> > >     /usr/bin/postmaster -o -i -D ${PGDATA}
> > > which I manually start with the "-d 5 & "@ the end.
> > >
> > > The "psql" commands works fine locally.
> > >
> > > pg_hda.conf contains the following line :
> > > # The same, over Unix-socket connections:
> > > #
> > > #  local  all     192.168.1.0     255.255.255.0   trust
> > >  host   all     192.168.1.0     255.255.255.0   trust
> > >
> > > Of course my network is 192.168.1.0 with a subnetmask of
> 255.255.255.0
> > >
> > > Trying to connect from another machine via JDBC gives the
> following
> > > error: "1109 [main] WARN org.test.JDBCPostgres.TestJDBCPostgres  -
> > > Message: Connection refused. Check that the hostname and port is
> > > correct, and that the postmaster is  running with the -i
> flag, which
> > > enables TCP/IP networking."
> > >
> > > Which is definitevely the case :
> > > $ ps -ef | grep post
> > >     postgres  6525  6456  0 14:40 pts/0    00:00:00
> > > /usr/bin/postmaster -o -i -D /da
> > >
> > > Does some one knows what is going wrong ?
> > >
> > > Thomas,
> > >
> > > --
> > > Thomas SMETS
> > > rue J. Wytsmanstraat 62
> > > 1050 Bruxelles
> > > yahoo-id: smetsthomas
> > >
> > >
> > >
> > >
> > >
> > >
> > > ---------------------------(end of
> > > broadcast)---------------------------
> > > TIP 1: subscribe and unsubscribe commands go to
> > > majordomo@postgresql.org
> > >
> > >
> > >
> > > ---------------------------(end of
> > > broadcast)---------------------------
> > > TIP 1: subscribe and unsubscribe commands go to
> > > majordomo@postgresql.org
> > >
> >
> > ---------------------------(end of
> broadcast)---------------------------
> > TIP 6: Have you searched our list archives?
> >
> > http://archives.postgresql.org
> >
>
>

pgsql-jdbc by date:

Previous
From:
Date:
Subject: Re: Problem to connect from host via JDBC ...
Next
From:
Date:
Subject: Re: Problem to connect from host via JDBC ...