pg_xlogfile_name_offset() et al and recovery - Mailing list pgsql-hackers

From Amit Langote
Subject pg_xlogfile_name_offset() et al and recovery
Date
Msg-id 573D7AAD.2060101@lab.ntt.co.jp
Whole thread Raw
Responses Re: pg_xlogfile_name_offset() et al and recovery  (Amit Langote <Langote_Amit_f8@lab.ntt.co.jp>)
List pgsql-hackers
Currently in HEAD and 9.6, one can issue a non-exclusive backup on
standby, so this is OK:

select pg_is_in_recovery();pg_is_in_recovery
-------------------t
(1 row)

select pg_start_backup('sby-bkp-test', 'f', 'f');pg_start_backup
-----------------0/5000220
(1 row)

However the following happens:

select pg_xlogfile_name_offset(pg_start_backup('sby-bkp-test', 'f', 'f'));
ERROR:  recovery is in progress
HINT:  pg_xlogfile_name_offset() cannot be executed during recovery.

Should this restriction be relaxed or am I missing something?

Thanks,
Amit





pgsql-hackers by date:

Previous
From: "Tsunakawa, Takayuki"
Date:
Subject: Re: foreign table batch inserts
Next
From: Jan Johansson
Date:
Subject: PostgreSQL and inherits