Re: What may be the url we need to use to connect the Postgres Database with Java

From: "Nick Fankhauser" <nickf(at)ontko(dot)com>
To: "Moovarkku Mudhalvan" <mudhalvan(at)vasunas(dot)com>, <pgsql-admin(at)postgresql(dot)org>
Subject: Re: What may be the url we need to use to connect the Postgres Database with Java
Date: 2001-10-15 13:14:13
Message-ID: NEBBLAAHGLEEPCGOBHDGCEHODMAA.nickf@ontko.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

jdbc(dot)oracle(dot)thin(at)ipaddress
> like this do we have any url need to be used in Postgres if so
> let me know.

jdbc:postgresql:database
jdbc:postgresql://host/database
jdbc:postgresql://host:port/database

if left out, host defaults to localhost- this is where you put your IP
address

if left out, port defaults to 5432

For example:

jdbc:postgresql://199.199.199.199/test

will connect you to the database named "test" on the host "199.199.199.199"

You will also need to have the database running with tcpip_socket set to "1"
or true in the postgresql.conf file, and set up authorization in pg_hba.conf
(search on these filenames in the interactive documentation for more.

-Nick

--------------------------------------------------------------------------
Nick Fankhauser nickf(at)ontko(dot)com Phone 1.765.935.4283 Fax 1.765.962.9788
Ray Ontko & Co. Software Consulting Services http://www.ontko.com/

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Nick Fankhauser 2001-10-15 13:22:37 Re: What is the default password for the user postgres..
Previous Message victor 2001-10-15 10:37:41 users sessions