General errors that occur during backup

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/conf
startPGSQL.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.
          • Related Articles

          • 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 ...
          • How is Backup Age calculated for MS SQL DB monitor?

            Backup Age displays the number of hours passed since the backup operation was completed. In simple terms, it is the difference between the current time and the time at which backup was performed. Backup Age (hours) = Current Time - Backup Time By ...
          • Active Directory Diagnostic Tests - Troubleshoot Errors in Specific test

            In Active Directory Monitor, Diagnostic tests have been introduced in build 14040. To troubleshoot any errors in a specific test in the Diagnostic tests tab, follow the below steps: 1) Open Powershell in administrator mode in the machine ...
          • General FAQs

            While adding the Web Transaction Monitor I get the message 'Service is not running. Web Transaction Agent may not have been deployed’. This happens even when I have deployed the agent in my application server. Check if the Web Transaction Agent is ...