google-cloud-platformgoogle-cloud-sqlpgrouting

PgRouting in GCP Cloud SQL

Is there any good reason why the pgrouting extension is still not supported by GCP Cloud SQL? I mean, Cloud SQL even supports PostGIS 2.3 version.

Also, considering I already have PostGIS 2.3 installed on Cloud SQL, is there any way I could install pgrouting manually without issuing the CREATE EXTENSION statement?

Thanks in advance.

Solution

  • As far as I'm aware, there's no way you can install pgRouting manually without using the CREATE EXTENSION statement, and as you already know, it's currently not supported unfortunately.

    However, I was able to find a public feature request open here for pgRouting to be supported by PostgreSQL (in CloudSQL). You could comment and follow updates there on the potential support for it in future.