>> Alex Ignatov started a new thread was started on this topic as well... >> >> https://www.postgresql.org/message-id/c571dfc5-91b0-0df2-4e3f-45bc94c11...@postgrespro.ru >> >> >>I posted a link to this thread on his new one as well. >> >>David J.
for completeness: same issue with data checksums enabled: (postgres@[local]:5555) [postgres] > show data_checksums ; data_checksums ---------------- on (1 row) Steps to reproduce: create table t1 ( a int ); insert into t1 values ( generate_series(1,1000000)); select count(*) from t1; => rm the table files => select count(*) still works (postgres@[local]:5555) [postgres] > select count(*) from t1; count --------- 1000000 (1 row) => then shutdown fast: LOG: received fast shutdown request LOG: aborting any active transactions FATAL: terminating connection due to administrator command LOG: autovacuum launcher shutting down LOG: shutting down FATAL: could not open file "base/13056/16384": No such file or directory CONTEXT: writing block 2946 of relation base/13056/16384 LOG: checkpointer process (PID 3004) exited with exit code 1 LOG: terminating any other active server processes LOG: abnormal database system shutdown => startup LOG: database system shutdown was interrupted; last known up at 2016-05-31 10:52:17 CEST LOG: database system was not properly shut down; automatic recovery in progress LOG: redo starts at 0/7070808 LOG: record with zero length at 0/76EECD0 LOG: redo done at 0/76EEC68 LOG: last completed transaction was at log time 2016-05-31 10:51:27.689776+02 LOG: MultiXact member wraparound protections are now enabled LOG: database system is ready to accept connections LOG: autovacuum launcher started (postgres@[local]:5555) [postgres] > select count(*) from t1; count -------- 186450 (1 row)
