I want a method to export osm files from a postgress database. I already have a osm2pgsql database, a apidb database and nominatim database in which I have imported osm files. Now I need to export osm files from a database with a osm2pgsql schema and use with the nominatim and api-db(openstreetmap-website) database.
I know that the osm2pgsql is a tool for populating a PostGIS database that allow we run the Mapnik rendering software, Nominatim search software, or our own geospatial queries and have a totally different database table structure to that required by the openstreetmap-website rails app.
But, I need to create for use in future imports using osmosis and osm2pgsql tools and for backup purposes.
Can anyone help me how to do this?