[SOLVED] how i install a postgis in Managed postgresql

how i install a postgis in Managed postgresql

i have a managed postgresql in oci , i want to install extension(postgis)

i just access to the primary by psql cli

 `postgres-> \dx
                 List of installed extensions
  Name   | Version |   Schema   |         Description          
---------+---------+------------+------------------------------
 plpgsql | 1.0     | pg_catalog | PL/pgSQL procedural language
(1 row)`

that a list of all extension ..

i try this command :

 postgres=> CREATE EXTENSION IF NOT EXISTS postgis;

and give me that error :

ERROR:  could not open extension control file "/usr/lib/postgresql/share/extension/postgis.control": No such file or directory

is there another way ?

thank you

Solution

Unfortunately, PostGIS isn't on the list of extensions supported by OCI. AWS RDS has it, Azure has it, Google Cloud SQL does have it, Oracle doesn't.