[closed] OSM data cant update in centOS 7

Hi,

We setup osm database server in centos 7.

But we cant update data in that server. Below query is running long time while trigger update. (I thing reading data is very slow or cant read)

COPY planet_osm_polygon (osm_id,access,addr:housename,addr:housenumber,addr:interpolation,admin_level,aerialway,aeroway,amenity,area,barrier,bicycle,brand,bridge,boundary,building,
construction,covered,culvert,cutting,denomination,disused,embankment,foot,generator:source,harbour,highway,historic,horse,intermittent,junction,landuse,layer,
leisure,lock,man_made,military,motorcar,name,natural,office,oneway,operator,place,population,power,power_source,public_transport,railway,ref,religion,
route,service,shop,sport,surface,toll,tourism,tower:type,tracktype,tunnel,water,waterway,wetland,width,wood,z_order,way_area,tags,way) FROM STDIN)

asked 19 May '17, 08:23

Rajavelu_M
253●45●48●58
accept rate: 33%

closed 20 Jun '17, 07:42

You need to provide more detail on what you are actually doing, including

hardware configuration that you are using
how much OSM data you imported country? region? the planet?
are you on the initial import or are you trying to update already imported data?

(19 May '17, 08:49) SimonPoole ♦

@SimonPoole: Thanks for your interest. My system config are: 32 core CPU, 128GB RAM & 2TB HD in centos 7. Already imported OSM data for whole country. This issue occurring while update only.

(19 May '17, 09:07) Rajavelu_M

"OSM data for whole country" - is this Vatican City, Monaco or maybe the US?

(19 May '17, 09:12) scai ♦

Sorry, its for whole planet.

(19 May '17, 09:18) Rajavelu_M

The question has been closed for the following reason "Problem is not reproducible or outdated" by Rajavelu_M 20 Jun '17, 07:42

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

*italic* or _italic_
**bold** or __bold__
link:[text](http://url.com/ "title")
image?![alt text](/path/img.jpg "title")
numbered list: 1. Foo 2. Bar
to add a line break simply add two spaces to where you would like the new line to be.
basic HTML tags are also supported

learn more about Markdown

Question tags:

tiles ×287
update ×199
postgresql ×165
slow ×33
centos ×7

question asked: 19 May '17, 08:23

question was seen: 1,461 times

last updated: 20 Jun '17, 07:42

[closed] OSM data cant update in centOS 7

The question has been closed for the following reason "Problem is not reproducible or outdated" by Rajavelu_M 20 Jun '17, 07:42

Follow this question

Related questions