VACUUM: Nonremovable rows due to wal sender process

2022-01-04 Thread Steve Nixon
I have PostgreSQL Version 10.7 on AIX 7.1 set up with streaming replication. Replication appears to be working fine and database contents are staying current. *ps -ef |grep sender* > postgres 54854022 30212254 0 10:10:29 - 0:00 postgres: wal sender > process postgres 10.253.15.123(47852) s

Re:VACUUM: Nonremovable rows due to wal sender process

2022-01-04 Thread Sergei Kornilov
Hello This is exactly the reason why you need to track the age of the oldest transaction on the primary itself and on every replica that has hot_standby_feedback = on. By default hot_standby_feedback is disabled. > Is there anything I can do short of shutting down and restarting the primary > (