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 acknowledge that you have read our updated terms of service, privacy policy and cookie policy, and that your continued use of the website is subject to these policies.