Data transfer to local ORMA instance

[KPGeo]

@geohacker @olafveerman

Gentlemen, Tai has set up another instance for ORMA that they control, but needs to transfer uploaded data to it. Can you assist him?

[geohacker]

Hi @KPGeo, I've uploaded a dump from the ORMA DB and uploaded this to S3 so the team can download and restore. Here are the instructions:

Restoring DB snapshot

• Download the snapshot https://openroads-vn-dumps-prod.s3-ap-southeast-1.amazonaws.com/production-07-11-2019.sql.zip
• Create a database, and ensure POSTGIS extension is enabled. To enable POSTGIS you can run create extension postgis
• Then restore using psql. psql -d dbname -f /path/to/snapshot.sql

Data stored on S3

Map tiles for the iD editor, database backups, and CBA CSV files are programmed to be written to an S3 bucket in the Tiler. The S3 bucket URL can be changed in the environment variable of the AWS stack. If you setup the database with the above data, and run the tiler, it should create all the CBA and tiles. If you prefer downloading them from S3, they are stored here:

1. DB dumps and CBA https://s3.console.aws.amazon.com/s3/buckets/openroads-vn-dumps-prod
2. Tiles https://s3.console.aws.amazon.com/s3/buckets/openroads-vn-tiles-prod/

You might need additional access to download the above, please let us know the AWS user account and we'll set it up.