Re: 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
>