I am trying to access postgresql database (7.3.2 - default with RedHat 9 distro) using JDBC. I have a Linux user called "oracle" that I have created in postgresql server also and gave that user privileges to create a database.
I tried to create a databse using createdb and it works.
The url that I am using in JDBC is: "jdbc ostgresql://localhost:5432/test
", "oracle", "". It reverts bck with error that says:
SQLException: Connection refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections.
Can anyone plz help? Thanks.