meta data for this page
  •  

issues

invalid primary checkpoint record

After unclean shutdown:

user=,db=,app=,client= LOG:  invalid primary checkpoint record
user=,db=,app=,client= PANIC:  could not locate a valid checkpoint record

Postgresql running from official docker container.

Solution:

Prevent container from restarting:

docker-compose stop db
docker-compose.yml
services:
  db:
    image: postgres:12-alpine
    command: bash

run it interactively:

docker-compose run db

and reset WAL:

su postgres -c '/usr/local/bin/pg_resetwal -f /var/lib/postgresql/data'