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.