From: | Luca Ferrari <fluca1978(at)gmail(dot)com> |
---|---|
To: | pgsql-general <pgsql-general(at)lists(dot)postgresql(dot)org> |
Subject: | cannot promote after recovery for PITR |
Date: | 2021-02-22 14:42:38 |
Message-ID: | CAKoxK+7=OnqSm8OpHDSWQWHk8zKfOd=yqKEdC0Lkq5AGAr7Rkw@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Oleksandr Voytsekhovskyy | 2021-02-22 15:00:43 | Simple IN vs IN values performace |
Previous Message | David G. Johnston | 2021-02-22 14:17:42 | Re: JSONB_AGG: aggregate function calls cannot be nested |