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 Applications Manager directory so that you don't make any changes/accidentally modify the database. Identify which database Applications ...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 ...ManageEngine Applications Manager High Availability setup with dual database (MySQL).
Apart from the Failover setup, which uses a single database and dual Application Server, we also support a failover with dual database and Application Server. Failover support requires you to configure Applications Manager Secondary (Standby server) ...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: ...Applications Manager Database Migration Using SQL Dump
Step 1: Rename Directories Skip this step if the directories are already renamed. Rename <AppManager_home>/working/pgsql to <AppManager_home>/working/pgsql_11. Rename <AppManager_home>/working/pgsql_15.5 to <AppManager_home>/working/pgsql. Step 1.1: ...