Is it possible to dump a postgres database that was created with osm2pgsql and a .osm.pbf file with pg_dump and import this into a remote postgres database?
After running osm2pgsql the database is 135 Gb. When I create the dump from postgres, I have an 80Gb file.
When I bzip the dump file I end up with a 17Gb compressed file.
I'm hoping this would be less resource intensive than running osm2pgsql on the remote server. The remote server has a max of 4 gigs of RAM, and resource limits are easily reached.
The import process took close to 7 hours on a 2.5 ghz MacBook Pro with 16 gigs of ram. I've been running osm2pgsql for the last two days using --slim and -C 3500.
This is the second time I'm attempting to import on the remote server with osm2pgsql. I'm thinking that importing a dump of the working database may be more efficient. Any advice would be appreciated.
Thanks.
أكثر...
After running osm2pgsql the database is 135 Gb. When I create the dump from postgres, I have an 80Gb file.
When I bzip the dump file I end up with a 17Gb compressed file.
I'm hoping this would be less resource intensive than running osm2pgsql on the remote server. The remote server has a max of 4 gigs of RAM, and resource limits are easily reached.
The import process took close to 7 hours on a 2.5 ghz MacBook Pro with 16 gigs of ram. I've been running osm2pgsql for the last two days using --slim and -C 3500.
This is the second time I'm attempting to import on the remote server with osm2pgsql. I'm thinking that importing a dump of the working database may be more efficient. Any advice would be appreciated.
Thanks.
أكثر...