Re: Problem to connect from host via JDBC ... - Mailing list pgsql-jdbc
From | Dave Cramer |
---|---|
Subject | Re: Problem to connect from host via JDBC ... |
Date | |
Msg-id | 00aa01c1c479$6d8eb340$8201a8c0@inspiron Whole thread Raw |
In response to | Re: Problem to connect from host via JDBC ... (<tsmets@brutele.be>) |
List | pgsql-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
pgsql-jdbc by date: