From: | Rui DeSousa <rui(at)crazybean(dot)net> |
---|---|
To: | Andrey Zhidenkov <andrey(dot)zhidenkov(at)gmail(dot)com> |
Cc: | pgsql-admin <pgsql-admin(at)postgresql(dot)org> |
Subject: | Re: hot_standby_feedback parameter doesn't work |
Date: | 2018-11-13 15:53:36 |
Message-ID: | 2B832E7A-146E-4818-B080-4EF15F0F291C@crazybean.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
> On Nov 13, 2018, at 4:18 AM, Andrey Zhidenkov <andrey(dot)zhidenkov(at)gmail(dot)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 are sending that information to the master.
What is the exact error message?
From | Date | Subject | |
---|---|---|---|
Next Message | Achilleas Mantzios | 2018-11-13 16:06:41 | Re: PostgreSQL 10.5 : Logical replication timeout results in PANIC in pg_wal "No space left on device" |
Previous Message | Pepe TD Vo | 2018-11-13 15:41:58 | Re: Ora2pg Not Getting Installed- Please Provide Inputs |