Brian, Thanks for the speedy response!
> The tables shouldn't have different SRIDs everything should be 4326. Looks like this was the result of two problems. 1. When I installed proj on CentOS I omitted the proj-nad and proj-epsg packages. 2. Somewhere along the way of trying to get things to work I added a '-m' flag to osm2pgsql. This fixed the immediate proj errors, but obviously introduced other projection errors later on. After fixing this I successfully imported the Vatican City and performed some searches. Yippee! I've since tried importing Denmark several times with various postgres.conf settings including the settings specified here: http://wiki.openstreetmap.org/wiki/Mapnik/PostGIS My server is a dual quad core with 16GB of RAM and 10GB of swap space and decent disks, yet the import of just Denmark (~60MB compressed) takes several hours and eventually crashes with the below message and all RAM and swap in use. The crash appears to occur on " insert into placex select * from place where osm_type = 'N';" in gazetteer-index.sql. WARNING: terminating connection because of crash of another server process DETAIL: The postmaster has commanded this server process to roll back the current transaction and exit, because another server process exited abnormally and possibly corrupted shared memory. HINT: In a moment you should be able to reconnect to the database and repeat your command. CONTEXT: PL/pgSQL function "add_location" line 24 at IF PL/pgSQL function "placex_insert" line 200 at assignment server closed the connection unexpectedly This probably means the server terminated abnormally before or while processing the request. connection to server was lost Thanks again! -jason _______________________________________________ Geocoding mailing list [email protected] http://lists.openstreetmap.org/listinfo/geocoding
