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
>
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 ? |