DP 10.03 | HP-UX | IDB Backup failed with "Putting the Internal Database into the backup mode failed"

  • KM03280023
  • 31-Oct-2018
  • 25-Mar-2021

Summary

IDB backup failed after recovery

Error

Putting the Internal Database into the backup mode failed

Cause

Analysis:
 
DP POSTGRES_BAR DEBUG:
 
[ 30] [BackupChangeMode] Error in output after BackupChangeMode, unexpected table contents
[ 30] [VarDbgDump] 9fffffffffffe588
(('NOTICE:  WAL archiving is not enabled; you must ensure that all required WAL segments are copied through other means to complete the backup'),('pg_stop_backup','2D/96137FA0'))
 
Cause:
 
archive_mode is off

Fix

When no DP active sessions found

1. Turn on archive_mode by adding into postgresql.conf this parameter

archive_mode = ON

2. Restart DP services