Search Postgresql Archives

cannot promote after recovery for PITR

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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





[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux