The following bug has been logged on the website:
Bug reference: 14481
Logged by: Zhou Digoal
Email address: digoal(at)126(dot)com
PostgreSQL version: 9.4.8
Operating system: CentOS 6.x x64
Description:
when our database upgrade from 9.4.2 to 9.4.8.
there some error when create table .
“could not read block 7 in file "base/16393/12769": read only 0 of 8192
bytes”
# select relname,relkind from pg_class where pg_relation_filepath(oid) ~
'16393/12769';
relname | relkind
------------+---------
pg_attrdef | r
(1 row)
after vacuum pg_attrdef
it's no error now.
but i don't known why?
this database is protect by these parameter :
datachecksum=on
fsync=on
full page write=on
sync commit =on
best regards
digoal