[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
Hans Bergsten
said
over 10 years ago
[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
anonymous