multiple PostgresQL installations

[Matthew Lunnon]

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 thatuses 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