#13 PostgreSQL 8.1.18 bug w/ invalid page header and pg_clog

[Sakari A. Maaranen]

OSM2PostGIS run ends with an exception like:

org.postgresql.util.PSQLException: ERROR: invalid page header in block 1391048 of relation "osm_way_nodes"

After that VACUUM ANALYZE to the same table fails:

routing=# vacuum analyze osm_way_nodes ;
ERROR: could not access status of transaction 2099456
DETAIL: could not open file "pg_clog/0002": No such file or directory

This problems has repeated even after building the whole database (of the whole world) again from scratch. From what I can find on the web, it seems others are having similar problems with similar and older PostgreSQL versions. It seems the recommended minimum version of PostgreSQL needs to be changed to a more recent one.

[Sakari A. Maaranen]

Just a quick update on the progress. I have now installed PostgreSQL 8.4.3 in my test environment, and also updated documentation on the dependencies that are now much simpler. Let's see if this is enough to fix this one.