[Tile-serving] osm2pg OOM

[Alex O'Ree]

Good questions.

> Are you trying to import the whole planet or an extract?
Trying to import the whole planet.

> What options are you using for osm2pgsql (or whatever else you're using to load)?

> What database schema are you using - something to render from, or a different one?

I'm guessing the default render one. I haven't specified anything specific

> Is updating the database afterwards with changes important?

yes

> Have you tried a smaller data extract, or does the problem occur no matter how little data you try and load?
Not yet, no.

> Do you have an option (such as with a virtual machine) to easily allocate more memory to it?
It's in a VM at the moment with like 4GB ram.

> The OS and version of osm2pgsql might be useful to know

Ubuntu 14 as it appears to be by far the easiest to run on. It would
make my life easier if windows was an option.




On Fri, Oct 9, 2015 at 8:57 AM, SomeoneElse <lists at atownsend.org.uk> wrote:
> It might be useful to know a bit more about what you're trying to do here...
>
> Are you trying to import the whole planet or an extract?  What options are
> you using for osm2pgsql (or whatever else you're using to load)? What
> database schema are you using - something to render from, or a different
> one?  Is updating the database afterwards with changes important?  Have you
> tried a smaller data extract, or does the problem occur no matter how little
> data you try and load?  Do you have an option (such as with a virtual
> machine) to easily allocate more memory to it? The OS and version of
> osm2pgsql might be useful to know too.
>
> I'm guessing that you've already had a look around and found discussion such
> as:
>
> http://gis.stackexchange.com/questions/104220/most-reliable-way-to-import-large-dataset-with-osm2psql
>
> With a few more specifics someone might be able to offer more concrete
> suggestions (such as in the answer to that question) that are more helpful
> than "import less" and "add more memory" :)
>
> Cheers,
>
> Andy
>
>
>
>
> On 09/10/2015 12:07, Alex O'Ree wrote:
>>
>> ping, still need help here
>>
>> On Fri, Oct 2, 2015 at 4:26 PM, Alex O'Ree <spyhunter99 at gmail.com> wrote:
>>>
>>> I was able to import the data into postgres but ran into an issue
>>> after the commit phase of the points, lines, polygons, and roads.
>>>
>>> Going Over pending ways...
>>> pending_ways failed: out of memory for query result
>>> (7)
>>> Error occurred, cleaning up
>>>
>>>
>>> What do I do from here?
>>
>> _______________________________________________
>> Tile-serving mailing list
>> Tile-serving at openstreetmap.org
>> https://lists.openstreetmap.org/listinfo/tile-serving
>
>
>
> _______________________________________________
> Tile-serving mailing list
> Tile-serving at openstreetmap.org
> https://lists.openstreetmap.org/listinfo/tile-serving