pg_xlogfile_name_offset() et al and recovery

Поиск
Список
Период
Сортировка
От Amit Langote
Тема pg_xlogfile_name_offset() et al and recovery
Дата
Msg-id 573D7AAD.2060101@lab.ntt.co.jp
обсуждение исходный текст
Ответы Re: pg_xlogfile_name_offset() et al and recovery  (Amit Langote <Langote_Amit_f8@lab.ntt.co.jp>)
Список 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 по дате отправления:

Предыдущее
От: "Tsunakawa, Takayuki"
Дата:
Сообщение: Re: foreign table batch inserts
Следующее
От: Jan Johansson
Дата:
Сообщение: PostgreSQL and inherits