BUG #18540: Does PG16 standby database support function pg_replication_origin_advance? - Mailing list pgsql-bugs

From PG Bug reporting form
Subject BUG #18540: Does PG16 standby database support function pg_replication_origin_advance?
Date
Msg-id 18540-eb48b78bd306c618@postgresql.org
Whole thread Raw
Responses Re: BUG #18540: Does PG16 standby database support function pg_replication_origin_advance?
List pgsql-bugs
The following bug has been logged on the website:

Bug reference:      18540
Logged by:          Does PG16  standby database support function pg_replication_origin_advance?
Email address:      jason.chentj@homecredit.cn
PostgreSQL version: 16.1
Operating system:   Red Hat Enterprise Linux Server release 7.9
Description:

Hi Guys, 

am testing the PG 16 VERSION standby database replicate slot function. when
I issue below command to move the offset for replicate slot on standby
database got below error: 

db_plumc=# select
pg_replication_origin_advance('standbyslot','5EE/5D1B13F8'::pg_lsn);
ERROR:  cannot manipulate replication origins during recovery


Seems the function pg_replication_origin_advance is not supported running on
standby instance.  It there any workaround for it? 

  
Thanks
Jason


pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: BUG #18536: Using WITH inside WITH RECURSIVE triggers a "shouldn't happen" error
Next
From: PG Bug reporting form
Date:
Subject: BUG #18541: Reattaching a partition referenced by a foreign key fails with an error