By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,834 Members | 2,265 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,834 IT Pros & Developers. It's quick & easy.

multiple PostgresQL installations

P: n/a
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
Nov 12 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.