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@postgresql.org
[mailto:pgsql-jdbc-owner@postgresql.org] On Behalf Of tsmets@brutele.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.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
>



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

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