Connection issues
Connection refused is one of the common connection issues when a PostgreSQL-compatible SQL client is unable to connect to a CockroachDB node. There can be many things that can go wrong here, such as expired certificates or firewall settings. Following are some general guidelines on what to look for in terms of connection related configurations:
- Check that the CockroachDB node is running and listening on the correct port.
- Check the connection details, especially the hostname and port number.
- If the node is running in secure mode, you have to make sure appropriate certificates and keys are generated and are being passed correctly during the connection.
- Make sure the client certificate is present and not expired.
- If the node is already running and the host and port are correct, you can try restarting the node and see if that helps with the connection issue.
- Check for firewall rules that prohibit specific inbound and outbound traffic....
