Closed SPlanzer closed 5 years ago
pg_dump -Fc -h prdassgeo02 gazetteer > gazetteer.dump
pg_restore -U postgres -h localhost -d gazetteer --no-owner gazetteer.dump
users are as follows:
GRANT bde_user TO gaz_dev_user;
GRANT gazetteer_admin TO gaz_dev_user;
GRANT gazetteer_dba TO gaz_dev_user;
Create gazetteer DB dump to be restored locally for porting (to QGIS3) / testing NZGB plugin