On 8/11/23 03:20, lejeczek wrote: [snip]
So, seeing logs flooded that way.... I don't like it (even if I could be sure everything is in sync) particularly for master shows:-> $ sudo -u postgres psql --port=5432 -x -c 'select client_addr,sync_state from pg_stat_replication;'could not change directory to "/root": Permission denied (0 rows)
Try this: sudo su - postgres -c "psql ..." -- Born in Arizona, moved to Babylonia.