FAQs
How to access PostgreSQL instance?
You can access it through the PostgreSQL Client. Log into your cloud host and input the following command into the command line:
psql -U$User -h$IP -p$port -d$postgres
$IP specifies the intranet IP address of the PostgreSQL instance.
$Port specifies the port number of the PostgreSQL instance.
$User specifies the administrator name of the PostgreSQL instance.
$postgres appoints the database.
For example, if you create a PostgreSQL instance on the console, the default port is 5432, the IP is 10.19.11.111, and the administrator is root:
psql -U root -h 10.19.11.111 -p 5432 -d postgres
PostgreSQL instances only support intranet login via the cloud host.
What is the maximum connection number for PostgreSQL?
max_connections is the maximum number of connections, that is, the maximum number of clients allowed to connect. Increasing the connection number can allow more clients to connect, but setting it too large may also cause the DB to fail to start. Currently, the PostgreSQL product with 1G memory supports 70 connections.