Openstreetmap Amazon EBS
Has anybody had any luck using Openstreetmap Amazon EBS ?
I just could not start Postgres, having created it using
pg_createcluster --locale=en_US -d /openstreetmap/data/ 8.3 osm
and then running it
pg_ctlcluster 8.3 osm start
Error:
Error: The server must be started under the locale : which does not exist any more.
Running locale -a on my ec2 (AMI ID: ami-b7aa4cde)
C
de_DE
en_US开发者_如何学编程
en_US.utf8
en_US.utf-8
en_US.UTF-8
hu_HU
hu_HU.utf8
POSIX
What am I missing?
Few pointers:
- Have to mount the EBS under /mnt/sdm , otherwise I have to modify the config file.
- I had no luck running it as a new cluster, so I just replaced the data directory in the default postgresql install dir with the /mnt/sdm
- Had to create data/pg_log and /var/run/postgresql directories.
- Had to increase kernel shared memory parameters so postgres can run
- Had to use x64 version of postgres
- Had to use postgres compiled with HAVE_64BIT_TIMESTAMP
Due to all these problems, I am just getting a fresh dump from openstreet planet, and hopefully can import it into my database.
精彩评论