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 |
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.
New to ADSelfService Plus?
Related Articles
Connecting to Applications Manager's bundled database
Before you connect to Applications Manager's back-end database, it is important that you take a backup of the AppManager directory so that you don't make any changes/accidentally modify the database. 1. Identify which database Applications Manager is ...Maintenance of Applications Manager backend database
Note: Please take complete database backup without fail prior to these steps. I. Applications Manager with PostgreSQL Database. Shutdown all Applications Manager related process as follows: For windows: Open services.msc --> stop ManageEngine ...Issues while upgrading Applications Manager with PostgreSQL backend database
Problem 1: After installing Applications Manager with PostgreSQL as backend (For versions 14850 and above), the following error message is shown due to error the initPGSQLDB.sh file because of missing GLIBC_2.9 library file: ./initdb: ...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 ...Unable to upgrade Applications Manager - MySQL Deprecation
Problem: You encounter the following error while trying to install service pack for Applications Manager v16140 and above: Reason: This error occurs because MySQL backend database has been deprecated in Applications Manager. Solution: You have to ...