Re: cannot promote after recovery for PITR

2021-02-23 Thread Luca Ferrari
On Mon, Feb 22, 2021 at 3:42 PM Luca Ferrari wrote: > If, instead, I do pg_wal_replay_resume(), the server is promoted (of > course not at the PITR I want). > Am I missing something? Apparently I was missing caffeine and confused the usage of the functions. pg_wal_replay_resume was what I was loo

cannot promote after recovery for PITR

2021-02-22 Thread Luca Ferrari
I'm running 12.5, I've restored a backup copy (from barman) to a specific restore point. The system has gone into pause, and I've checked that everything is as I was expecting. Now I'm unable to promote the cluster: testdb=# SELECT pg_is_wal_replay_paused(); pg_is_wal_replay_paused --