My HD ran out of space while a postgres was running. I had to kill postgres and freed some space. Now I am not able to restart postgres with the following error message:
LOG: listening on IPv4 address "0.0.0.0", port 5434 LOG: listening on IPv6 address "::", port 5434 LOG: listening on Unix socket "/tmp/.s.PGSQL.5434" LOG: database system was interrupted; last known up at 2018-04-16 05:20:46 EDT PANIC: could not read file "pg_logical/replorigin_checkpoint": Success LOG: startup process (PID 97490) was terminated by signal 6: Aborted LOG: aborting startup due to startup process failure LOG: database system is shut down
data/pg_logical there exists a file with the name
replorigin_checkpoint but it is empty.
I already copied the data directory for backup reasons as suggested here but I am actually not really sure what to do next.
amcheck looks like, it is only working on a running postgres.
postgres (PostgreSQL) 11devel
Ubuntu 16.04.4 LTS
Maybe it is worth noting, that the file system is itself mounted on that machine (
1. What is supposed to be inside
2. Is there the possibility to restart from an earlier checkpoint?
3. What type of corruption repairings are out ther (not only corruption detection)