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

Thomas

You need to replace the outside single quotes with double quotes and
then single quote the -o '-i'

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 1: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(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
>

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/users-lounge/docs/faq.html