cannot promote after recovery for PITR

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|

cannot promote after recovery for PITR

Luca Ferrari-2
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
-------------------------
 t
(1 row)

testdb=# select pg_promote( true, 120 );
WARNING:  server did not promote within 120 seconds
 pg_promote
------------
 f


and the only thing I've got into the logs is

WARNING:  server did not promote within 120 seconds

Similarly, I cannot promote via pg_ctl even if I've checked that
PGDATA/promote is there.


If, instead, I do pg_wal_replay_resume(), the server is promoted (of
course not at the PITR I want).
Am I missing something?

Thanks,
Luca


Reply | Threaded
Open this post in threaded view
|

Re: cannot promote after recovery for PITR

Luca Ferrari-2
On Mon, Feb 22, 2021 at 3:42 PM Luca Ferrari <[hidden email]> 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 looking for.

Sorry for the noise.

Luca