I am facing max_connections error during database restoration on ApsaraDB for PostgreSQL in a local database.

I am using below mentioned command for database restoration

\i c:/mydb1.sql

This error is caused by the large number of connections. To solve this problem, we recommend that you set the max_connections values of both the master and slave instances to 800 or less.

The max_connections values for the master and slave instances are required to be the same. For details, see Server Configuration and Server Setup and Operation on the official website of PostgreSQL.

Please Click here for detailed information.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy