pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Tom Haddon <thaddon@equilar.com>
To: Mohammad Tanvir Huda <shayer009@yahoo.com>
To: pgsql-admin@postgresql.org
Subject: Re: Connecting Postgres using other network
Date: Wed, 11 Aug 2004 12:59:45 -0700
Message-ID: <0E52D69E86D25840AAE3611CB657F9F80AA023@millenium.equilar.com> (raw)

Just to check, you are using a non-standard port (6432 - the standard is
5432)?

	-----Original Message-----
	From: pgsql-admin-owner@postgresql.org
[mailto:pgsql-admin-owner@postgresql.org] On Behalf Of Mohammad Tanvir
Huda
	Sent: Wednesday, August 11, 2004 12:40 PM
	To: pgsql-admin@postgresql.org
	Subject: [ADMIN] Connecting Postgres using other network 
	
	
	Hello Everyone 
	 
	I have installed Postgres server in a network and  i am trying
to use the database using 
	Java code from other network. 
	 
	I have set the tcp_ip=true in postgresql.conf file. 
	I have also add the follwing line in the pg_hba.conf
	
	host    all         all        127.0.0.0
255.255.255.255   trust
	 
	Then i start the server in port 6432. 
	 
	After that i want to access the application using the following
javacode. 
	 
	import java.sql.*;   // All we need for JDBC
	import java.text.*;
	import java.io.*;
	public class HelloPost
	{
	  Connection       db;        // A connection to the database
	  Statement        sql;       // Our statement to run queries
with
	  DatabaseMetaData dbmd;      // This is basically info the
driver delivers
	                              // about the DB it just connected
to. I use
	                              // it to get the DB version to
confirm the
	                              // connection in this example.
	  public HelloPost()
	    throws ClassNotFoundException, SQLException
	  {
	    String database = "test";
	    String username = "abc";
	    String password = "xyz";
	    try{
	     Class.forName("org.postgresql.Driver"); file://load the
driver
	        db =
DriverManager.getConnection("jdbc:postgresql://abc.csse.uts.edu:6432:tes
t",
	                                     username,
	                                     password); file://connect
to the db
	     dbmd = db.getMetaData(); file://get MetaData to confirm
connection
	     System.out.println("Connection to
"+dbmd.getDatabaseProductName()+" "+
	                       dbmd.getDatabaseProductVersion()+"
successful.\n");
	     sql = db.createStatement(); file://create a statement that
we can use later
	    }catch (ClassNotFoundException e) {
	            System.err.println( "Driver not found: " + e + "\n"
+ e.getMessage() );
	    }
	    db.close();
	  }
	 public static void main (String args[])
	   {
	     try
	     {
	       HelloPost demo = new HelloPost();
	     }
	     catch (Exception ex)
	     {
	       System.out.println("***Exception:\n"+ex);
	       ex.printStackTrace();
	     }
	   }
	 }
	
	But this give me the following error 

	Exception: org.postgresql.util.PSQLException: Connection
refused. Check that the hostname and port are correct and that the post
	 accepting TCP/IP connections.
	Connection refused. Check that the hostname and port are correct
and that the postmaster is accepting TCP/IP connections.
	
	Can anyone please tell me where is the error. what should i doo
.. 
	 
	regards 
	 
	Shayer 
	 

	
________________________________

	Do you Yahoo!?
	Yahoo! Mail
<http://us.rd.yahoo.com/mail_us/taglines/50x/*http://promotions.yahoo.co
m/new_mail/static/efficiency.html>  - 50x more storage than other
providers!

view thread (10+ messages)  latest in thread

Message-ID: <0E52D69E86D25840AAE3611CB657F9F80AA023@millenium.equilar.com>
Permalink:  ../0E52D69E86D25840AAE3611CB657F9F80AA023@millenium.equilar.com/
Also on:    postgresql.org/message-id/0E52D69E86D25840AAE3611CB657F9F80AA023@millenium.equilar.com

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-admin@postgresql.org
  Cc: thaddon@equilar.com, shayer009@yahoo.com
  Subject: Re: Connecting Postgres using other network
  In-Reply-To: <0E52D69E86D25840AAE3611CB657F9F80AA023@millenium.equilar.com>
  References: <0E52D69E86D25840AAE3611CB657F9F80AA023@millenium.equilar.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox