Received: from oscar.broadcom.ie (oscar.broadcom.ie [192.107.110.20]) by hub.org (8.8.8/8.8.8) with ESMTP id GAA07808 for ; Wed, 21 Oct 1998 06:15:02 -0400 (EDT) (envelope-from jr@broadcom.ie) Received: from broadcom.ie (jr@pc13.broadcom.ie [192.107.110.113]) by oscar.broadcom.ie (8.8.8/8.8.8) with ESMTP id LAA15691; Wed, 21 Oct 1998 11:13:23 +0100 (BST) Sender: jr@broadcom.ie Message-ID: <362DC1B1.150E1E12@broadcom.ie> Date: Wed, 21 Oct 1998 12:12:49 +0100 From: John Reilly Organization: Broadcom Eireann Research Ltd. X-Mailer: Mozilla 4.06 [en] (X11; I; Linux 2.0.34 i686) MIME-Version: 1.0 To: pmcglauchlin@gr.com CC: pgsql-interfaces@postgreSQL.org Subject: Re: [INTERFACES] Where can I get documentation on the using the JDBC interface? References: <002a01bdfb7f$c4210a80$df35d7ce@pmcglauchlin.gr.com> Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Phil McGlauchlin wrote: > I am trying to get the jdbc interface to work but I keep getting a > SQLException "connection refused". First of all, make sure you are running the postmaster with the "-i" option. > Is this a userid/password problem? I first tried the url without a user, > then with "postgres" and no password, and finally with a new user I created. > I used the createuser command to create the user but I couldn't figure out > how to set the password. edit the pg_hba.conf to set the hosts that are allowed to access the db To change user details like the password, use psql. type "\h alter user" for syntax details John -- ----------------------------------------------------------------------------- John Reilly, | Phone: +353 1 6046006 Broadcom Eireann Research Ltd., | Fax: +353 1 6761532 Kestrel House, | Email: jr@broadcom.ie Clanwilliam Place, | Dublin 2, Ireland | -----------------------------------------------------------------------------