[Tile-serving] osm2pg OOM

[SomeoneElse]

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