Re: Problem to connect from host via JDBC ...

Yes but if I change it to

su -l postgres -c '/usr/bin/pg_ctl -D ${PGDATA} -p
/usr/bin/postmaster -i start' >/dev/null 2>&1

I doesn't start

Thomas,

--
Thomas SMETS
rue J. Wytsmanstraat 62
1050 Bruxelles
yahoo-id : smetsthomas

----- Original Message -----
From: "Rouyre Frédéric" <Frederic(dot)Rouyre(at)osl(dot)be>
To: "'pgsql jdbc'" <pgsql-jdbc(at)postgresql(dot)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(at)micro-automation(dot)net]
> > Sent: Tuesday, March 05, 2002 2:22 PM
> > To: tsmets(at)brutele(dot)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(at)postgresql(dot)org
> > [mailto:pgsql-jdbc-owner(at)postgresql(dot)org] On Behalf Of
> > tsmets(at)brutele(dot)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(at)postgresql(dot)org
> >
> >
> >
> > ---------------------------(end of
> > broadcast)---------------------------
> > TIP 1: subscribe and unsubscribe commands go to
> > majordomo(at)postgresql(dot)org
> >
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org
>