[OSM-dev] Mapnik import of planet delayed due to Postgres problem

[Martijn van Oosterhout]

On Nov 8, 2007 10:04 AM, Jon Burgess <jburgess777 at googlemail.com> wrote:
> I've tried to run the osm2pgsql import for the latest planet dump twice
> and both times Postgres has returned a deadlock error near the end of
> the processing:-

<snip>
> I'll investigate further and see whether an update to the server or some
> tweaks to the SQL commands can fix it. One suggestion I've found on the
> net is that the auto-vacuum is interfering with things.

Some older versions of postgresql had possible deadlocks between
autovacuum and cluster. If you're only running mapnik on the cluster,
you can probably just disable it.

Have a nice day,
-- 
Martijn van Oosterhout <kleptog at gmail.com> http://svana.org/kleptog/