Esri / ops-server-config

Operations Server Configuration scripts
Apache License 2.0
34 stars 13 forks source link

Investigate other methods of distributing the PostgreSQL content #259

Open elinz opened 10 years ago

elinz commented 10 years ago

Currently, we are distributing the PostgreSQL content by exporting the data to file geodatabases, which the CopyData.py script copies into the target PostgreSQL geodatabases.

Investigate other methods. For example, SQL Server allows you to create a disconnected database, which you can attach to another SQL Server instance; research if PostgreSQL has something similar. This may be faster then copying the data from the "distribution" file geodatabases.

elinz commented 10 years ago

Check out this link http://stackoverflow.com/questions/1237725/how-to-copy-postgres-database-to-another-server