Start a new topic

problem with Database connection with postgreSQL

[This topic is migrated from our old forums. The original author name has been removed]

HI, I am new to postgreSQL and dbVis ... and i am having connection error Product: DbVisualizer Free 9.1.6 Build: #2117 (2014/01/26 21:20) Java VM: Java HotSpot(TM) Client VM Java Version: 1.7.0_45 Java Vendor: Oracle Corporation OS Name: Windows 7 OS Arch: x86 OS Version: 6.1 An error occurred while establishing the connection: Long Message: Connection refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections. Details:    Type: org.postgresql.util.PSQLException    SQL State: 08001 Can anybody suggest me what data i should fill in database server and database port? I keep it as default. Thanks in advance...
1 Comment

[This reply is migrated from our old forums.]

Re: problem with Database connection with postgreSQL
Hi, You should enter the IP address or DNS name of the server where the database runs as the Database Server and the port it listens to for TCP/IP connections, by default 5432. After you have entered this, please use the Ping Server button to see if you can reach that server and port. If you get an error message, you have either entered incorrect Database Server or Port values, there is a firewall that blocks the connection, or the PostgreSQL server is not configured to access connections from your PC. If Ping Server says everything is fine but you still cannot connect, the problem is most likely with the login credentials for the user account you specify. I hope this helps, Hans