Patronictl Status

PostgreSQL
1

Hi,

Why is patronictl state showing " streaming "? This status is normal " running ".

  • Cluster: patroni -------------±----------±—±----------+
    | Member | Host | Role | State | TL | Lag in MB |
    ±---------±---------------±-------------±----------±—±----------+
    | xxx | 1.1.1.0 | Leader | running | 7 | |
    | xxx | 1.1.1.1 | Sync Standby | streaming | 7 | 0 |
    ±---------±---------------±-------------±----------±—±----------+
2

Hi,

Offhand it sounds like you’re running synchronous replication and not async replication. Login to your LEADER and perform this query:

select * from pg_stat_replication;

Hope this helps.

3

Hello,
This is a new behavior of Patroni that was introduced recently.
Now instead of “running” you will see either “streaming” if replica is streaming changes from another postgres node, or “in archive recovery” if you are recovering WALs from the archive.

1 Like
4

Thanks a lot of. Thats true.
Regards.