I started vacuum full. Tim Am 07.09.2011 03:00, schrieb Kai Krueger:
> > > Things people have suggested to try and fix it: > > 1) 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? > > 2) 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) > > 3) 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 > > _______________________________________________ Maps-l mailing list [email protected] https://lists.wikimedia.org/mailman/listinfo/maps-l
