Why can't I get the result from patronictl list ?

[vasilytray]

why aren't all cluster nodes getting the same error?
What did I do wrong?

root@z34096:~/postgresql_cluster# patronictl list
2023-03-09 11:37:21,548 - WARNING - Listing members: No cluster names were provided

root@z34096:~/postgresql_cluster# sudo systemctl status patroni.service
● patroni.service - Runners to orchestrate a high-availability PostgreSQL - Patroni
     Loaded: loaded (/etc/systemd/system/patroni.service; enabled; vendor preset: enabled)
     Active: active (running) since Thu 2023-03-09 10:52:51 UTC; 44min ago
   Main PID: 27323 (patroni)
      Tasks: 18 (limit: 3440)
     Memory: 252.2M
        CPU: 1min 53.916s
     CGroup: /system.slice/patroni.service
             ├─27323 /usr/bin/python3 /usr/local/bin/patroni /etc/patroni/patroni.yml
             ├─27387 /usr/lib/postgresql/15/bin/postgres -D /var/lib/postgresql/15/main --config-file=/etc/postgresql/15/main/postgresql.conf --listen_addresses=192.168>             
├─27389 "postgres: PSQL-cluster: logger " "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "">             
├─27390 "postgres: PSQL-cluster: checkpointer " "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "">             
├─27391 "postgres: PSQL-cluster: background writer " "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" >             
├─27393 "postgres: PSQL-cluster: walwriter " "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "">             
├─27394 "postgres: PSQL-cluster: autovacuum launcher " "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" ">             
├─27395 "postgres: PSQL-cluster: archiver last was 000000010000000000000005" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" >             
├─27396 "postgres: PSQL-cluster: logical replication launcher " "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" ">             
├─27401 "postgres: PSQL-cluster: postgres postgres [local] idle" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" >             
├─27836 "postgres: PSQL-cluster: walsender replicator 192.168.171.2(62216) streaming 0/6000060" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "">             
├─27843 "postgres: PSQL-cluster: walsender replicator 192.168.171.3(24712) streaming 0/6000060" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "">             
└─47151 "postgres: PSQL-cluster: postgres postgres 127.0.0.1(37492) idle" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" >

[vitabaks]

Try patronictl -c /etc/patroni/patroni.yml list

[vasilytray]

Thank you very much. Perhaps it would have helped, but it was not possible to check. during the night, the situation corrected itself, but it is still not clear why and how.

Last login: Thu Mar  9 10:37:59 2023 from 192.168.171.1
root@pgnode03:~# patronictl list
+ Cluster: PSQL-cluster ---+--------------+---------+----+-----------+
| Member   | Host          | Role         | State   | TL | Lag in MB |
+----------+---------------+--------------+---------+----+-----------+
| pgnode01 | 192.168.171.1 | Leader       | running |  1 |           |
| pgnode02 | 192.168.171.2 | Sync Standby | running |  1 |         0 |
| pgnode03 | 192.168.171.3 | Replica      | running |  1 |         0 |
+----------+---------------+--------------+---------+----+-----------+

[vitabaks]

perhaps you just re-logged in to the server, and in this case, the rule from /etc/environment worked.

[vasilytray]

Thank you very much