Question :
I am using Postgres 12 and have a master and slave setup. I am also running Barman on our secondary server in the meantime.
When looking in pg_stat_activity I see:
START_REPLICATION 0/42000000 TIMELINE 1
I have my wal_level set to logical and archive_mode set to on but am confused why I am seeing this in pg_stat_activity.
This server is new and has no traffic going on it at the moment, is this the reason why I am seeing the message? Am trying to find out online some information surrounding this but have had no joy.
If I run ps -eaf|grep postg|grep stream I do see that it is streaming.
Any help is much appreciated.
Answer :
I found a good explanation on:
TLDR:
PostgreSQL 13.4, 12.8, 11.13, 10.18: walsender processes show their latest replication commands in pg_stat_activity. Filter out with WHERE backend_type = 'walsender'
.