<div dir="ltr">Hello,<div><br></div><div>What would I have to do in order to use PostGIS on a remote server that I am connected to?<br><div><br></div><div>I am fairly new to PostGIS and have been setting it up for use (I have PostgreSQL 9.6.18 and PostGIS 3.0). I have both local databases located on my computer and databases on remote servers that I connect to. When I use the CREATE commands available at <a href="https://postgis.net/install/">https://postgis.net/install/</a>, PostGIS sets up fine on my local databases (I have PostGIS installed through the StackBuilder with pgAdmin). </div></div><div><br></div><div>When I try to do the same on a server I am remotely connected to, I get the following error: </div><div><span style="background-color:transparent;font-family:"Source Code Pro",SFMono-Regular,Menlo,Monaco,Consolas,"Liberation Mono","Courier New",monospace;font-size:12.8px;white-space:pre-wrap"><br></span></div><div><span style="background-color:transparent;font-family:"Source Code Pro",SFMono-Regular,Menlo,Monaco,Consolas,"Liberation Mono","Courier New",monospace;font-size:12.8px;white-space:pre-wrap">"ERROR:  could not open extension control file "/usr/pgsql-9.6/share/extension/postgis.control": No such file or directory</span></div><span style="background-color:transparent;font-family:"Source Code Pro",SFMono-Regular,Menlo,Monaco,Consolas,"Liberation Mono","Courier New",monospace;font-size:12.8px;font-variant-numeric:normal;font-variant-east-asian:normal;white-space:pre-wrap">SQL state: 58P01"</span><div><span style="background-color:transparent;font-family:"Source Code Pro",SFMono-Regular,Menlo,Monaco,Consolas,"Liberation Mono","Courier New",monospace;font-size:12.8px;font-variant-numeric:normal;font-variant-east-asian:normal;white-space:pre-wrap"><br></span></div><div><span style="background-color:transparent;font-family:"Source Code Pro",SFMono-Regular,Menlo,Monaco,Consolas,"Liberation Mono","Courier New",monospace;font-size:12.8px;font-variant-numeric:normal;font-variant-east-asian:normal;white-space:pre-wrap">Does this mean I would have to have PostGIS somehow installed on the remote server as well or is it possible to use it with the local installation that I have?</span></div><div><span style="background-color:transparent;font-family:"Source Code Pro",SFMono-Regular,Menlo,Monaco,Consolas,"Liberation Mono","Courier New",monospace;font-size:12.8px;font-variant-numeric:normal;font-variant-east-asian:normal;white-space:pre-wrap"><br></span></div><div><span style="background-color:transparent;font-family:"Source Code Pro",SFMono-Regular,Menlo,Monaco,Consolas,"Liberation Mono","Courier New",monospace;font-size:12.8px;font-variant-numeric:normal;font-variant-east-asian:normal;white-space:pre-wrap">Thanks,</span></div><div><span style="background-color:transparent;font-family:"Source Code Pro",SFMono-Regular,Menlo,Monaco,Consolas,"Liberation Mono","Courier New",monospace;font-size:12.8px;font-variant-numeric:normal;font-variant-east-asian:normal;white-space:pre-wrap">Akshay</span></div></div>