There are a number of GUI client applications that you can use to manage PostgreSQL databases from your computer, remotely over the internet. These applications enable you to view databases, run SQL queries, and more.
Perhaps the most popular and widely-used client application is pgAdmin. This app is free to download & use and there are versions available for almost every operating system, including the major ones like Windows, macOS, and Linux.
This Knowledgebase article will cover how to remotely connect to the database server using pgAdmin so you can run queries and more from your computer.
How to connect remotely to PostgreSQL Database using pgAdmin
Before you are able to successfully connect remotely using pgAdmin, you must contact ChemiCloud support and ask that the IP address from the system you are remotely using be whitelisted on the server.
Additionally, some internet service providers, notably Comcast, may block connections over port 5432 and you may need to use a VPN or a different network to connect. ChemiCloud is not able to circumvent this for you if it’s a limitation from your ISP.
First, you’ll need to download the latest version of pgAdmin. Click here to open the download pages for the application.
Once the application has been downloaded, install it on your computer.
For this tutorial, we are using pgAdmin 4 version 5.1.
The first time you open pgAdmin, you need to set up the server so the app knows where to connect. Click Add New Server.
The create server screen will open.
Proceed by giving the connection a name that you will remember, for example – it might say something like, my blog database, or ChemiCloud PostgreSQL.
When you’ve finished, click the Connection tab at the top.
Use the fields in the Connection tab to configure a connection:
- Enter the IP address or server hostname you wish to connect to. For example, this could be the IP address 1.2.3.4 or a server hostname, like server.serverhostgroup.com.
- Enter the listener port number of the server host in the Port field. The default is 5432.
- Use the Maintenance database field to specify the name of the database to which you want to connect.
- Use the Username field to specify the username assigned to the database to which you’re connecting.
- Use the Password field to provide a password that goes with the database user account you’re using.
- Check the box next to Save password? to instruct pgAdmin to save the password for future use if you want.
When you’ve finished, click Save. The pgAdmin app will attempt to connect to the server automatically, and the setting will be changed so the next time you open pgAdmin, you’ll be able to connect easily.
Are you struggling with PostgreSQL connectivity issues? ChemiCloud is the hosting solution designed to save you time! 🤓 Check out our web hosting plans!
Your explanation is incomplete, you take the screenshot of the HMI, you have to give a complete example.
shit