On Wed, 2023-01-18 at 17:47 -0600, Don Seiler wrote: > PostgreSQL 12.13 (PGDG packages) in a streaming replication configuration. > pgBackrest 2.43 used for WAL archiving and DB backups to cloud storage > > I'm testing and documenting a DR exercise process where I: > 1. Cleanly shutdown PG on the primary > 2. Promote the PG DR replica > 3. Place the standby.signal file on the old primary and start it up > (presumes no other configurations need changing, primary_conninfo > etc were already set). > My hope is I could just start the old primary / new replica if it was > cleanly shutdown prior to promoting the replica. Yes, that should work. > However when I try to start up that new replica, I'm met with: > > LOG: restored log file "00000002000000B70000005A" from archive > LOG: invalid resource manager ID in primary checkpoint record > PANIC: could not locate a valid checkpoint record > LOG: startup process (PID 17660) was terminated by signal 6: Aborted > LOG: aborting startup due to startup process failure > LOG: database system is shut down What do you get for "pg_controldata -D datadir | grep checkpoint"? Can you show the complete log from the point the server started? Yours, Laurenz Albe
