[OSM-dev] OSM2PGSQL in slim mode

[Amir Pourabdollah]

Hi OSM Dev,

I have an OSM database in PostGIS updated daily using OSM2PGSQL in slim
mode. As you know the two tables planet_osm_nodes and planet_osm_ways are
acting as temporary tables for the update process however I noticed that
their size are incremented every day, thus slowing down the process. My
solution so far has been doing a normal (non-slim mode) run of OSM2PGSQL
every few months so it refreshes everything but this method is not
preferred since the system is not functioning during the execution. Any
idea on how to clean the database without a fresh OSM2PGSQL run?
Thanks,
Amir. 

On 27/11/2013 10:19, "Grant Slater" <openstreetmap at firefishy.com> wrote:

>Hi OSM Dev,
>
>The sysadmin team is planning to switch to a new planet-dump processes
>shortly.
>We have produced an experimental dump using the new method and we
>would appreciate it if people could test.
>
>Matt's description of the new process:
>
>"This planet dump program operates in a very different way from the
>previous one; rather than force the database server to keep a
>consistent context open for the duration of the dump [Grant: +30
>hours], it instead uses a consistent [Grant: backup] dump from the
>database. This means that running the extraction from PostgreSQL dump
>file to planet file(s) is completely independent of the database
>server, and can be done on a disconnected machine without putting any
>load on any database."
>
>The experimental planet-dump is available here:
> http://planet.openstreetmap.org/planet/experimental/
>
>25 Nov 2013 dump will be added shortly.
>
>Bugs reports are best reported here:
> https://github.com/zerebubuth/planet-dump-ng
>
>Regards
> Grant
> Part of OSM sysadmin team
>
>_______________________________________________
>dev mailing list
>dev at openstreetmap.org
>https://lists.openstreetmap.org/listinfo/dev

This message and any attachment are intended solely for the addressee and may contain confidential information. If you have received this message in error, please send it back to me, and immediately delete it.   Please do not use, copy or disclose the information contained in this message or in any attachment.  Any views or opinions expressed by the author of this email do not necessarily reflect the views of the University of Nottingham.

This message has been checked for viruses but the contents of an attachment
may still contain software viruses which could damage your computer system, you are advised to perform your own checks. Email communications with the University of Nottingham may be monitored as permitted by UK legislation.