Postgres Pro
Downloads
Home   >   mailing lists

pg_get_wal_replay_pause_state() should not return 'paused' while a promotion is ongoing. - Mailing list pgsql-hackers

From Fujii Masao
Subject pg_get_wal_replay_pause_state() should not return 'paused' while a promotion is ongoing.
Date
Msg-id f706876c-4894-0ba5-6f4d-79803eeea21b@oss.nttdata.com
Whole thread Raw
Responses Re: pg_get_wal_replay_pause_state() should not return 'paused' while a promotion is ongoing.
Re: pg_get_wal_replay_pause_state() should not return 'paused' while a promotion is ongoing.
List pgsql-hackers
Tree view 
If a promotion is triggered while recovery is paused, the paused state ends
and promotion continues. But currently pg_get_wal_replay_pause_state()
returns 'paused' in that case. Isn't this a bug?

Attached patch fixes this issue by resetting the recovery pause state to
'not paused' when standby promotion is triggered.

Thought?

Regards,

-- 
Fujii Masao
Advanced Computing Technology Center
Research and Development Headquarters
NTT DATA CORPORATION
Attachment

pgsql-hackers by date:

Previous
From: Bharath Rupireddy
Date:
Subject: Re: postgres_fdw - should we tighten up batch_size, fetch_size options against non-numeric values?
Next
From: Tom Lane
Date:
Subject: Re: pg_dumpall misses --no-toast-compression