Cloud PostgreSQL & PostGIS
It is essential to ensure that your Cloud PostgreSQL instances are patched with the latest updates to maintain optimal performance and security. Regular updates help protect against vulnerabilities and improve functionality. However, it's important to also pay attention to the PostGIS extension, especially for those using Enterprise Geodatabases in the Cloud. Many users often overlook the necessity of updating PostGIS, which can lead to missing out on crucial enhancements and new features that improve spatial data handling and analysis. Keeping both PostgreSQL and the PostGIS extension up to date is key to maximizing the effectiveness of your geospatial applications. For further information on upgrading the PostGIS extension, please refer to my white papers provided below.
How to Upgrade the PostgreSQL and PostGIS version for the Enterprise Geodatabase on Windows
How to Upgrade the PostgreSQL and PostGIS version for the Enterprise Geodatabase on Linux
How to Move the PostgreSQL Enterprise Geodatabase with pg_dump and pg_restore
How to Configure Windows Authentication for the PostgreSQL Enterprise Geodatabase
Mapping and Charting Solutions (MCS) Enterprise Databases Best Practices
