Skip to main content
commvault.com commvault.com
Question

PostgreSQL - No wal-archive files to backup, and the job failes.

  • October 29, 2025
  • 4 replies
  • 47 views
ApK
Byte
Forum|alt.badge.img+7

Hi all.

 

I have a question regarding PostgreSQL.

We have a PostgresSQL server with very little activity. We do a daily backup of the server with the option set to make a “Archive Delete” of the logs. 

Some times it happens that no new WAL files have been created, so the backup job goes to pending with the below error message:

 

Error Code: [94:66]
Description: PostgreSQL     Database: The Data backup has failed. Archive Log files are missing     preventing this job from completing on Instance     [~xxxxx_5434~] Client     [~xxxxxx~]. Please run a FULL backup.
Source:xxxxxx, Process: PostGresLogBackupParent
 

What can be done so I do not get a pending/failed job and so I do not need to run a full backup? Are there any secret additional setting there can be set to ignore this and make the job complete successful?

 

 

Thanks

-Anders

 

4 replies

Sunil
Vaulter
Forum|alt.badge.img+13
  • SunilVaulter
  • Vaulter
  • October 29, 2025

Hi ​@ApK ,

We will check how we can address this.

But if you can create a pre-backup script to switch log of the PostgreSQL instance, this should make sure there is at least one log file and completes the job successfully.

Which CV version we have here?

 

Thanks,

Sunil-

 

ApK
Byte
Forum|alt.badge.img+7
  • ApK
  • Author
  • Byte
  • October 29, 2025

Hi Sunil.

 

I will look into the possibility to create a script even though it would be better if this could be ignored in Commvault. 

At the moment we are on 11.32.119, but plan to upgrade to 11.40 during next year.

 

A second question comes to my mind; why can’t Commvault automatically convert the pending job to a full backup job. For MSSQL if something have happened to the transaction log and a full backup needs to be run, the backup automatically converts the backup to a full backup for the specific database. Would be nice if something similar could be done with PostgreSQL

 

Regards

-Anders

Sunil
Vaulter
Forum|alt.badge.img+13
  • SunilVaulter
  • Vaulter
  • October 29, 2025

Hi Anders,

You’re bang right on. This automatic conversion is done automatically in SP40.

 

Thanks,

Sunil-

L
ApK
Byte
Forum|alt.badge.img+7
  • ApK
  • Author
  • Byte
  • October 29, 2025

Hi Sunhil.

 

Great news with 11.40. Another reason to upgrade. We do have more than 200 PostgreSQL server backups running, and this is a rather time consuming task for us.

 

Regards

-Anders

Terms & ConditionsCookie settingsAccessibility statement