Failed to backup database with Full backup

Application issues
1

I’ve seen this issue in prior posts, but the options to remedy seem to be missing in the 12.7.0 build. What is the current fix?

7/29/2022 3:02:22 PM [Error] Failed to backup “NNN” database with “Full” backup type: C:\Program Files (x86)\SQLBackupAndFTP\DBMS\PostgreSql\pg_dump.exe process has finished with “1” code. The error message: “pg_dump: error: query failed: ERROR: permission denied for relation BtClipProcParams
pg_dump: error: query was: LOCK TABLE public.“BtClipProcParams” IN ACCESS SHARE MODE”.

2

Hi Joshua_Baca,

The issue you faced is related to your PostgreSQL settings, and the problem cannot be resolved from our side. The error message you receive says that there are not enough permissions on pg_dump. Please find more details on how to resolve the problem on the web.

If you have any other questions, please let us know.

Thank you and sorry for the inconvenience.