I remembered that I wrote an article, "I tried to display location data using QGIS and Cloud SQL PostgreSQL & PostGIS," about two years ago. This time, I tried to build PostgreSQL & PostGIS database with Amazon Aurora and display it with QGIS!
To begin, create a database in Amazon Aurora.
Set public access, create a new security group, and put the initial database name. All other settings are default. Although it will not be used in the production environment, it can be accessed directly from the local PC by setting it to Public Access.
This completes the configuration of Amazon Aurora 👍
The next step is to install PostGIS and import the GIS data.
This time we will use DBeaver to connect to Amazon Aurora. Set the endpoint, port, database name, user name, and password you copied to the hostname.
After connecting to Amazon Aurora, install PostGIS.
CREATE EXTENSION postgis;
Verify that it is installed.
As for importing data, I imported 1 million point data.
Regarding the import method, I imported the data with the DB manager of QGIS. Still, I could not import the data correctly with Amazon RDS as I wrote in the previous article. This time, I used "shp2pgsql" to import the data.
This completes the configuration of PostGIS 👍
Finally, connect to Amazon Aurora in QGIS and display the data.
By using QGIS and Amazon Aurora, I checked the data directly from my local PC. This seems to be a good use when you want to share data within your company, etc.! However, I think the disadvantage is a pay-as-you-go fee, unlike preparing a DB locally.
I want to try PostgreSQL & PostGIS in Amazon RDS in the future 💪