Exporting a section of a Postgres OSM database

Are there any tools available that would allow me to import the whole world into a Postgres database and then export sections as required as a .sql file?

I want to set up a fairly powerful ‘server’ that will hold all the data and then export smaller sections to be imported unto a 32-bit Postgres database for use with a mobile application. The mobile device does no have the power/memory to import directly. I believe that using .sql is the only way of converting between 64-bit postgres (on the server) and 32-bit postgres on the mobile device but I stand to be corrected.


maybe you can ask at http://help.openstreetmap.org … there are some more guys familiar with databases than in this subforum, I assume.