Re: connectivity problem - Mailing list pgsql-jdbc
From | Paul Thomas |
---|---|
Subject | Re: connectivity problem |
Date | |
Msg-id | 20040130112223.A6795@bacon Whole thread Raw |
In response to | connectivity problem (adp adp <adp_group2004@yahoo.co.in>) |
List | pgsql-jdbc |
On 30/01/2004 09:51 adp adp wrote: > I am using postgreSQL 7.3,j2sdk1.4.2 and have > installed jdbc driver as pg73jdbc3.jar > > > Here is the classpath : > exportCLASSPATH=/root/j2sdk1.4.2/bin/test1.java:/root/j2sdk_nb/j2sdk1.4.2/jre/lib/ext/pg73jdbc3.jar:. > > and here is the code: > > import java.sql.*; > class test2{ > public static void main (String args[]) { > > > try{ > > > Class.forName("org.postgresql.Driver"); > > > > String > url="jdbc:postgresql://127.0.0.1/test"; > Connection con = > DriverManager.getConnection(url, "postgres", ""); > Statement stm= con.createStatement(); > > > stm.setQueryTimeout(10); > ResultSet rs = stm.executeQuery("select col1 from > test1"); > > > rs.next(); > > > System.out.println(rs.getString(1)); > }catch(ClassNotFoundException e) { > > > > > System.out.println("Exception"); > System.out.println(e.toString()); > } > catch(SQLException e) { > > > > > System.out.println("Exception"); > System.out.println(e.toString()); > } > } > } > > and now I receive this error irrespective of the host > and port address used in the url: > Exception > Connection refused. Check that the hostname and port > are correct and that the postmaster is accepting > TCP/IP connections. > > > next I tried the foll: > > [root@ws128 bin]# postmaster -c tcpip_socket=true > "root" execution of the PostgreSQL server is not > permitted. > > > The server must be started under an unprivileged user > id to prevent > a possible system security compromise. See the > documentation for > more information on how to properly start the server. > > Then I tried this: > [root@ws128 bin]# su postgres > bash-2.05b$ postmaster -c tcpip_socket=true > postmaster does not know where to find the database > system data. > You must specify the directory that contains the > database system > either by specifying the -D invocation option or by > setting the > PGDATA environment variable. > > > I think the problem is with postmaster settings, I > tried to set tcpip_socket into the postgresql.conf > file but it didnt work. > Please help. 1) You haven't told told the postmaster where it's data directory is 2) The error message shows you what to do to correct this 3) I find it easier to edit postgresql.conf to set tcpip_socket = true 4) Unless you installed PostgreSQL yourself from source, it's probably available as a service. Consult your OS/distribution documentation 5) I'd suggest you move your JDK to a directory under /usr. Either /usr/java or /usr/local/java would be ok. Otherwise you're going to have to run all your Java apps as root and that would be _really_ stupid. -- Paul Thomas +------------------------------+---------------------------------------------+ | Thomas Micro Systems Limited | Software Solutions for the Smaller Business | | Computer Consultants | http://www.thomas-micro-systems-ltd.co.uk | +------------------------------+---------------------------------------------+
pgsql-jdbc by date: