the standby node is unable to view the citus_tables view when backing up the database.

**How to **reproduce****
Database version: PostgreSQL 16.6 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 4.8.5
Citus version: Citus 12.1.4 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 4.8.5

**Problem Description:**

In a Patroni-based high-availability environment for Citus cluster backup, the standby node is unable to view the citus_tables view when backing up the database.

**Executing commands on Coordinator/Worker nodes results in an error description：**
postgres=# select * from citus_shard_sizes() css(shard_id, size);
**ERROR:** writing to worker nodes is not currently allowed
DETAIL: the database is read-only
postgres=# select * from citus_tables;
**ERROR:** writing to worker nodes is not currently allowed
DETAIL: the database is read-only