multiple PostgresQL installations

From: "Matthew Lunnon" <mlunnon(at)rwa-net(dot)co(dot)uk>
To: <pgsql-general(at)postgresql(dot)org>
Subject: multiple PostgresQL installations
Date: 2003-12-04 17:27:43
Message-ID: 01e401c3ba8c$083eff80$8e8bbd3e@rwanet.co.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi all,

We're running multiple PostgresQL database installations, each on a separate port. This works fine and

psql -p <port number> template1

works and connects to the correct instance of the database.

We have a problem with JDBC connections though. We have an application that uses Resin and connects to the database via a jdbc driver. When we use, for example:

jdbc:postgresql://<server>:5436/<database name>, it fails to connect with "No database available" errors, implying it can't see any database on that port. Connecting to a database on the standard postgresql port works fine, as long as you don't specify the port number in the connection string. This is all on one box, so firewalls etc aren't an issue.

We're using PostgresQL 7.3.4 with the pg73jdbc3.jar jdbc driver. If anyone has any ideas what the problem might be I'd be grateful for some pointers....

Thanks
Matthew

Browse pgsql-general by date

  From Date Subject
Next Message John Sidney-Woollett 2003-12-04 17:56:33 Re: Transaction Question
Previous Message Manfred Koizar 2003-12-04 16:55:00 Re: Transaction Question