RE: Connecting postgreSQL using JDBC

From: Matthew <matt(at)ctlno(dot)com>
To: "'Howard'" <kstse(at)netvigator(dot)com>, pgsql-general(at)postgresql(dot)org(dot)pgsql-questions(at)postgresql(dot)org
Subject: RE: Connecting postgreSQL using JDBC
Date: 2000-06-28 05:13:19
Message-ID: 183FA749499ED311B6550000F87E206C0C925B@SRV
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

What access does your pg_hba.conf provide for? I think it defaults to
only allowing local access. In order to connect to it from remote
machines the -I option needs to be given to postmaster and the
pga_hba.conf needs to allow connection from that IP to that data base
for that user.

Matt

> -----Original Message-----
> From: Howard [SMTP:kstse(at)netvigator(dot)com]
> Sent: Tuesday, June 27, 2000 10:29 PM
> To: pgsql-general(at)postgresql(dot)org(dot)pgsql-questions@postgresql.org
> Subject: [GENERAL] Connecting postgreSQL using JDBC
>
> I have just tried a sample Java program. It connects the PostgreSQL
> through
> the JDBC. I ran it on the postgreSQL machine. It works fine. But, when
> I
> tried to run it in another machine and connecting the database through
> the
> network. The connection was refused. I have no idea what is wrong.
>
> postgreSQL:
> startup with 'postmaster -i'
> java program:
> ...DriverManager.getConnection ("jdbc:postgresql:webtest",
> "nobody",
> "");
> where webtest is my testing database name.
>
> -- Howard
>

Browse pgsql-general by date

  From Date Subject
Next Message igor 2000-06-28 06:47:47 problems with transactions in C++Builder
Previous Message Tom Lane 2000-06-28 04:38:33 Re: Inserting into views