> On Nov 13, 2018, at 4:18 AM, Andrey Zhidenkov <andrey.zhidenkov@xxxxxxxxx> wrote: > > Yes, they are streaming replicas. Could you please tell me how to > check xmin of the replica in pg_stat_activity? I didn't get the point. > select pid , usename , application_name , backend_start , backend_xmin , state from pg_stat_replication ; select pid , state , backend_xid , backend_xmin , backend_type , backend_start from pg_stat_activity where backend_xmin is not null ; Vacuum will use the xmin to determine if a record is still needed or not thus I just wanted to make sure the replica are sending that information to the master. What is the exact error message?
