Skip to content

Instantly share code, notes, and snippets.

@gnepud
Created October 23, 2019 14:12
Show Gist options
  • Save gnepud/98da812130ec79bf942e4e038b0ab02e to your computer and use it in GitHub Desktop.
Save gnepud/98da812130ec79bf942e4e038b0ab02e to your computer and use it in GitHub Desktop.
[Postgresql docker] PANIC: could not locate a valid checkpoint record
mkdir {pg_commit_ts,pg_dynshmem,pg_tblspc,pg_twophase,pg_stat,pg_stat_tmp,pg_replslot,pg_snapshots,pg_logical}
mkdir pg_logical/{snapshots,mappings}
mkdir pg_xlog/archive_status
docker run -it -v /path/to/postgres_data:/var/lib/postgres/data postgres:9.6 /bin/bash
gosu postgres pg_resetxlog -f /var/lib/postgres/data
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment