Error message while performing database backup of Applications Manager
While performing a database backup operation of Applications Manager build with Pgsql backend, you may encounter the following error, especially when your database size has grown bigger with a large number of tables.
pg_dump: WARNING: out of shared memory pg_dump: SQL command failed pg_dump: Error message from server: ERROR: out of shared memory HINT: You might need to increase max_locks_per_transaction. |
Reference screenshot:

Cause
The error is caused by insufficient value of Max_locks_per_transaction parameter in the PostgreSQL.conf file. This parameter controls the average number of object locks allocated for each transaction. The default value of this parameter is 64.
Solution
To overcome this error, perform the steps below:
Navigate to AppManager_Home\working\pgsql\data\amdb in your Applications Manager installation.
Uncomment the line #max_locks_per_transaction = 64 in the postgresql.conf file
Increase the value of max_locks_per_transaction to a higher value, eg. max_locks_per_transaction = 10000
Restart the Applications Manager.
Take backup of the database again.
Related Articles
Applications Manager DB Maintenance for PGSQL Backend
Windows Installations Note: Please take complete db backup using the <AppManager Home>\bin\BackupPGSQLDB.bat (or BackupPGSQLDB.sh) script without fail before following the below steps: Open services.msc, stop “ManageEngine Applications ...
Connecting to Applications Manager's bundled database
How can I connect to Applications Manager's back-end database? Note: Take a backup of the AppManager directory before modifying anything in the database. Check am.dbserver.type value in <Applications Manager Home>\conf\AMServer.properties file to ...
Maintenance of Applications Manager
Applications Manager with MySQL database Open services.msc, stop “ManageEngine Applications Manager” service or via command prompt with administrator permission. If using command prompt, navigate to <Applications Manager Home> directory and execute ...
Issues while upgrading Applications Manager with PostgreSQL backend database
Problem 1: After installing Applications Manager versions 14850 and above with PostgreSQL backend, following error message is shown due to error initPGSQLDB.sh because of GLIBC_2.9 not found: ./initdb: /lib64/libc.so.6: version `GLIBC_2.9' not found ...
Steps to configure Azure PostgreSQL Database as Applications Manager's back-end
Applications Manager comes bundled with PostgreSQL. If you want to use your own PostgreSQL instead, follow the steps mentioned below: Prerequisites: A compatible PostgreSQL database should be accessible from Applications Manager installation. To know ...