> On Nov 13, 2018, at 4:18 AM, Andrey Zhidenkov <andrey.zhidenkov@gmail.com> 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
aresending that information to the master.
What is the exact error message?
