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

From: Rouyre Frédéric <Frederic(dot)Rouyre(at)osl(dot)be>
To: "'pgsql jdbc'" <pgsql-jdbc(at)postgresql(dot)org>
Subject: Re: Problem to connect from host via JDBC ...
Date: 2002-03-05 14:35:49
Message-ID: B3120923FCE6D411AF9300E0180439276B9FA6@oslxch01.osl.be
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-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
>

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Elmo 2002-03-05 15:05:04 PostgreSQL+PHP+JDBC+Java Smart Card
Previous Message Dave Cramer 2002-03-05 13:39:06 Re: RE : is anyone use executeQuery with autogeneratedkeys function ?