Querying the PostgreSQL backups

The nbpgsql -o query command lists previously backed up files according to the options that you specify.

The parameter -S is the required parameter. You can use the -C and -P options to define a different client and policy.

For example, to query a backup from client ClientA, run the following command:

nbpgsql -o query -S primary_server [-C ClientA]

For example, to list backup files with the policy name policy_name, run the following command:

nbpgsql -o query -S primary_server [-P policy_name]