I started vacuum full. Tim
Am 07.09.2011 03:00, schrieb Kai Krueger:
Things people have suggested to try and fix it:
- Run a vacuum full on the database.
What is the current strategy for vacuuming the database? Is Auto-vacuum turned on, or manual vacuums run?
- Create the missing pg_clog file as an empty file
dd if=/dev/zero of=/var/lib/pgsql/data/pg_clog/0AE1 bs=256K count=1
I think that might cause some data loss, although it might help to recover the rest of the database (which in our case isn't necessary as one can recreate it from other sources)
- Dump the database and then do a full restore. In our case, it would
be probably easier to simply drop the db and do a fresh import via osm2pgsql.
If 3) turns out to be the only possibility, it might be a good time to upgrade to postgresql 9.0
Kai