Lab prerequisites
Included in the lab activities of this chapter, you will be creating a PostgreSQL instance. The exercises and examples will work on clusters, instances, or serverless versions of Aurora as long as you are running PostgreSQL with PostGIS installed. Before starting with the geospatial database setup, ensure you have the following:
- AWS account with administrative privileges
- Desktop software for geographic information system (GIS) data visualization (QGIS, ArcGIS Pro, and so on)
- Sample shapefile of data to load into the geodatabase
An important aspect of using geospatial data is the relationship between clusters, instances, databases, schemas, and tables. A cluster refers to one or more instances of PostgreSQL that provide both additional scale and resiliency for your geospatial database. Instances within the cluster can be designated as the primary instance supporting both read and write operations or a read-only replica instance. All of the instances...
