When you see this in your PostgreSQL log:
ERROR: invalid page header in block 13760 of relation base/16995/67484
or that, when doing your database dump:
pg_dump: SQL command failed
pg_dump: Error message from server: ERROR: invalid page header in block 11947 of relation base/16995/17062
pg_dump: The command was: COPY public.samaged_table (column1, column2, column3, ...) TO stdout;
it is likely your PostgreSQL server has hardware issues or has crashed (or, the VM host, as in my case). If it’s the case, pg_dump / pg_dumpall will error and exit when seeing a corrupted block.
Unfortunately, it mean’s you’ll loose some data, so depending on what you have in your database, you may resort to some other methods.
Here is a quick way to fix it:
Continue reading ‘ERROR: invalid page header in block 13760 of relation base/16995/67484’ »