Обсуждение: Connecting Postgres using other network

-----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:test",
                                     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 - 50x more storage than other providers!

Cheryl Bender
-----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 2: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:test",
                                     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 - 50x more storage than other providers!

Cheryl Bender
-----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 2: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:test",
                                     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 - 50x more storage than other providers!

Cheryl Bender
-----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 2: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:test",
                                     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 - 50x more storage than other providers!

-----Original Message-----
From: pgsql-admin-owner@postgresql.org [mailto:pgsql-admin-owner@postgresql.org]On Behalf Of Mohammad Tanvir Huda
Sent: Thursday, August 12, 2004 10:00 AM
To: pgsql-admin@postgresql.org
Subject: Re: [ADMIN] Connecting Postgres using other network

Hello

 

i have made some entry in pg_hba.conf so that it can accept call from other computers.

 

But it still giving me the same error .

 

Can anyone pls tell me what is wrong with that

 

Regards

Mohammad
Mohammad Tanvir Huda <shayer009@yahoo.com> wrote:

Hello All

Thanks for your reply.

i want to use the port 6432 because some other instance of Postgresql is running on default port 5432,. And the psql command in this port works fine.

 

/scratch/huda/bin/psql -p 6432 test

 

If i want to allow any ip to get access to database what should i do.

is the following this legal

 

host template1 all 192.*.*.*  255.255.255.0 ident sameuser

 

Because when i hooked my PC to network it is assigned a dynamic IP .

 

thirdly, as mentioned in previous email where can i find the psql client tool.

 

Regards

 

Tanvir

"Bender, Cheryl" <cbender@mriresearch.org> wrote:

Cheryl Bender
-----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 2: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:test",
                                     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 - 50x more storage than other providers!

-----Original Message-----
From: pgsql-admin-owner@postgresql.org [mailto:pgsql-admin-owner@postgresql.org]On Behalf Of Mohammad Tanvir Huda
Sent: Thursday, August 12, 2004 10:00 AM
To: pgsql-admin@postgresql.org
Subject: Re: [ADMIN] Connecting Postgres using other network

Hello

 

i have made some entry in pg_hba.conf so that it can accept call from other computers.

 

But it still giving me the same error .

 

Can anyone pls tell me what is wrong with that

 

Regards

Mohammad
Mohammad Tanvir Huda <shayer009@yahoo.com> wrote:

Hello All

Thanks for your reply.

i want to use the port 6432 because some other instance of Postgresql is running on default port 5432,. And the psql command in this port works fine.

 

/scratch/huda/bin/psql -p 6432 test

 

If i want to allow any ip to get access to database what should i do.

is the following this legal

 

host template1 all 192.*.*.*  255.255.255.0 ident sameuser

 

Because when i hooked my PC to network it is assigned a dynamic IP .

 

thirdly, as mentioned in previous email where can i find the psql client tool.

 

Regards

 

Tanvir

"Bender, Cheryl" <cbender@mriresearch.org> wrote:

Cheryl Bender
-----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 2: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:test",
                                     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 - 50x more storage than other providers!

-----Original Message-----
From: Mohammad Tanvir Huda [mailto:shayer009@yahoo.com]
Sent: Thursday, August 12, 2004 8:29 PM
To: Andrew Janian
Cc: pgsql-admin@postgresql.org
Subject: Re: [ADMIN] Connecting Postgres using other network

I set the tcp_ip=true in postgresql.conf file. Isn't that the same thing while starting up postmaster with -i. Becasue i am starting up the server using pg_ctl .

 

Regards

 

Andrew Janian <ajanian@scottrade.com> wrote:

-----Original Message-----
From: pgsql-admin-owner@postgresql.org [mailto:pgsql-admin-owner@postgresql.org]On Behalf Of Mohammad Tanvir Huda
Sent: Thursday, August 12, 2004 10:00 AM
To: pgsql-admin@postgresql.org
Subject: Re: [ADMIN] Connecting Postgres using other network

Hello

 

i have made some entry in pg_hba.conf so that it can accept call from other computers.

 

But it still giving me the same error .

 

Can anyone pls tell me what is wrong with that

 

Regards

Mohammad
Mohammad Tanvir Huda <shayer009@yahoo.com> wrote:

Hello All

Thanks for your reply.

i want to use the port 6432 because some other instance of Postgresql is running on default port 5432,. And the psql command in this port works fine.

 

/scratch/huda/bin/psql -p 6432 test

 

If i want to allow any ip to get access to database what should i do.

is the following this legal

 

host template1 all 192.*.*.*  255.255.255.0 ident sameuser

 

Because when i hooked my PC to network it is assigned a dynamic IP .

 

thirdly, as mentioned in previous email where can i find the psql client tool.

 

Regards

 

Tanvir

"Bender, Cheryl" <cbender@mriresearch.org> wrote:

Cheryl Bender
-----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 2: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:test",
                                     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 - 50x more storage than other providers!