General errors that occur during backup
Here are some general errors that occur during backup and how to fix them:
Error 1:
“Initializing backup process"pg_dump: [archiver (db)] connection to database "amdb" failed: FATAL: no pg_hba.conf entry for host "::1", user "postgres", database "amdb", SSL off"BackupDB failed"
Reason:
In pg_hba.conf file the entry for the
host ::1 of ipv6 is commented
Solution:
- Go to AppManager_Home/working/pgsql/data/amdb folder
- Open pg_hba.conf file
- At the end of the file, uncomment the following highlighted lines
#
IPv6 local connections:
host all all ::1/128 md5
Error 2:
Connection
exception occur in err.txt
Reason:
The connection to the database is not
established. It may be due to port mismatch or because the port is already occupied.
Solution:
Check the port number in following
files:
database_params.conf -> Location: AppManager_Home/working/conf/AMServer.properties -> Location: AppManager_Home/confstartPGSQL.bat/sh -> Location: AppManager_Home/working/bin
All the files should have the same port number.
Also, if it is already occupied by some
other process, then change the port number in all the files as common, then run
the script.
New to ADSelfService Plus?
Related Articles
Troubleshooting errors that occur while adding Microsoft 365 monitor (For versions upto 16300)
Prerequisites: Ensure that you have met all the prerequisites for the Microsoft 365 monitor. From Applications Manager version 16300 onwards, Microsoft 365 monitor will use Microsoft Graph API as the primary mode of data collection. We have migrated ...Troubleshooting WinRM errors
This KB serves as a guide for troubleshooting errors when using the WinRM mode of data collection. First, ensure that all the following conditions are met: Refer to the below link and check if all the WinRM prerequisites have been completed properly ...Troubleshooting errors that occur during monitor addition and data collection in Microsoft 365 monitor (For versions 16310 onwards)
From Applications Manager version 16310 onwards, Microsoft 365 monitor will use Microsoft Graph API as the primary mode of data collection. We have migrated from PowerShell to Graph API as Microsoft 365 PowerShell commands were taking more time to ...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 ...List of files needed for troubleshooting Backup and Restore issues
List of Files needed for troubleshooting Backup and Restore Issue are as follows: Files for Backup Issue: err.txt ----> AppManager_Home/working/pgsql/bin Once script completely executed check the backup zip file under AppManager_Home/working/backup ...