Skip to content

Instantly share code, notes, and snippets.

View gnepud's full-sized avatar

Peng Du gnepud

  • Grenoble, France
View GitHub Profile
@gnepud
gnepud / gist:98da812130ec79bf942e4e038b0ab02e
Created October 23, 2019 14:12
[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