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.