Re: Problem to connect from host via JDBC ... - Mailing list pgsql-jdbc
From | |
---|---|
Subject | Re: Problem to connect from host via JDBC ... |
Date | |
Msg-id | 012601c1c46e$a9f5f600$6501a8c0@calvin Whole thread Raw |
In response to | Re: Problem to connect from host via JDBC ... (Rouyre Frédéric <Frederic.Rouyre@osl.be>) |
List | pgsql-jdbc |
Yes but if I change it to su -l postgres -c '/usr/bin/pg_ctl -D ${PGDATA} -p /usr/bin/postmaster -i start' >/dev/null 2>&1 I doesn't start 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 >
pgsql-jdbc by date: