| 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: | Whole Thread | Raw Message | 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 |