hackoregon / transportation-systems

Hack Oregon Repository to develop code for the Transportation Theme of CIVIC.
MIT License
5 stars 2 forks source link

Eliminate the need for PostGIS in the deployed PostgreSQL server #25

Closed znmeb closed 4 years ago

znmeb commented 6 years ago

See https://github.com/hackoregon/transportation-systems-ridership-analysis/issues/4 for the details.

znmeb commented 6 years ago

Changed title to more accurately describe the underlying issue - the deployed AWS box only has PostgreSQL, not PostGIS. We can and most likely will use PostGIS for analysis and data processing. We just have to strip out geometry columns and the PostGIS extension before creating pg_dump backups for loading into the AWS server.