What Should I Do If a Job with PostgreSQL/GaussDB as the Source Fails to Be Started and Error "permission denied for function pg_ls_waldir" Is Reported?

Symptom

A real-time job with PostgreSQL/GaussDB as the source fails to be started and error "permission denied for function pg_ls_waldir" is reported.

Possible Causes

For a real-time job with PostgreSQL/GaussDB as the source, the WAL diagnosis function pg_ls_waldir is used to view the mapping between the log sequence number (LSN, which records the log location) and timestamp. This function requires the monitor permission.

You can use this function to locate the corresponding log file when specifying the start point or query the replication slot progress point.

Solution

Grant the required permission to the account (username configured in the data connection) used by the real-time synchronization job.

For details about how to grant permissions, see How Do I Add Additional Permissions for PostgreSQL and GaussDB Data Sources?