caiut
1 Copper

Networker doesn't save Postgresql backup_label file

Hi All,

We do "physical" backup of our Postgres databases using Networker.

Physical backup or online backup or base backup is simply copy of the data directory of Postgres (PGDATA)

The process is simple:

1. call the db function pg_start_backup()

2. do backup of PGDATA (using any method: cp, scp, rsync, tar, Networker, Data Protector, TSM ... whatever)

3. call the db function pg_stop_backup()

It's working for +10 years in differente tools.

In Networker we call the functions using Pre Command and Pos Command and everything was ok.

But recently in our Recovery Tests we've found problems. After a lot of tests we found out that a specific file is missing of the backup.

This file is called backup_label, it's a kind of backup control file and it is created by pg_start_backup() and removed by pg_stop_backup()

We couldn't understand why the file isn't present in backup.

In manual simulations the file is always created when pg_start_backup() is called.

We have even checked the source code (1) of Postgres and the file is really synchronous persisted by the function.

Please, we appreciate any help or idea.

Info: Networker 9.2.1.2, client is CentOS 7.5, filesystem XFS

(1) https://doxygen.postgresql.org/xlog_8c.html#ada59fe1810e6ba2d2d4207259689a73a

Regards

Caiut

0 Kudos
1 Reply
caiut
1 Copper

Re: Networker doesn't save Postgresql backup_label file

Hi,

The problem just happens in clients with Agent version 8.

Upgrading the Agents to 9 solved the problem.

Regards

Caiut

0 Kudos