How Can I Install a PostgreSQL Client?
PostgreSQL provides client installation methods for different OSs on its official website.
The following describes how to install a PostgreSQL 12 client in CentOS.
Procedure
- Log in to an ECS.
- When you create an ECS, select an OS like CentOS 7 and bind an EIP to it.
- Use a remote connection tool to connect to the ECS through the EIP.
- Open the client installation page.
- Select a DB engine version, OS, and OS architecture, and run the following commands on the ECS to install a PostgreSQL client.
sudo yum install -y https://download.postgresql.org/pub/repos/yum/reporpms/EL-7-x86_64/pgdg-redhat-repo-latest.noarch.rpm sudo yum install -y postgresql12-server
Figure 1 Installing a client
- Select a DB engine version that is consistent with that of your RDS for PostgreSQL instance.
- Select an OS that is consistent with that of the ECS.
- Select an OS architecture that is consistent with that of the ECS.
Figure 2 Installing the RPM package
Figure 3 Client installed
- Connect to the RDS for PostgreSQL instance.
Figure 4 Connection successful
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.