alank Posted July 15, 2018 Share Posted July 15, 2018 HiI have created my Postgres database on johnny and am trying to use phppgadmin to create a postgis extension via SQL... without success. SQL error: ERROR: could not open extension control file "/usr/share/pgsql/extension/postgis.control": No such file or directory In statement: Create extension postgis; Is there something else I need to be doing? Thanks Link to comment Share on other sites More sharing options...
wolstech Posted July 15, 2018 Share Posted July 15, 2018 If I recall correctly, we don't support postgis on Johnny. Link to comment Share on other sites More sharing options...
alank Posted July 15, 2018 Author Share Posted July 15, 2018 Thanks for the prompt reply. Is Postgis supported on any of the other servers? If so am I able to move? Link to comment Share on other sites More sharing options...
wolstech Posted July 15, 2018 Share Posted July 15, 2018 I'm not sure which ones it's supported on honestly. It may even be possible to make it supported on Johnny now that it's been rebuilt. Let's see what our other root admin Krydos says. Link to comment Share on other sites More sharing options...
alank Posted July 15, 2018 Author Share Posted July 15, 2018 Thanks for that - it would be good if I could get remote access as well, if that isn't too much to ask. CheersAlanK Link to comment Share on other sites More sharing options...
Krydos Posted July 16, 2018 Share Posted July 16, 2018 Does postgis work now? We'll need to know what user and database you want remote access from. Link to comment Share on other sites More sharing options...
alank Posted July 17, 2018 Author Share Posted July 17, 2018 Thanks Krydos,We are closer, but no quite there: SQL error:ERROR: permission denied to create extension "postgis"HINT: Must be superuser to create this extension. In statement:create extension postgis Is it possible for me to connect as a super user? I would like to have access to "alank_backloader" as "alank" Cheers Link to comment Share on other sites More sharing options...
Krydos Posted July 17, 2018 Share Posted July 17, 2018 Is it possible for me to connect as a super user?No, you may not have access to view/modify/delete everyone's databases on the entire server. I can run the command for you though. I would like to have access to "alank_backloader" as "alank"Remote access enabled. Link to comment Share on other sites More sharing options...
alank Posted July 17, 2018 Author Share Posted July 17, 2018 Thanks for enabling remote access. I wasn't actuallywanting access as the postgres user...When I created the database (using the PostgreSQL Wizard) I was asked to create a "privileged user".I thought that this user would have privileges for the database I created... but I can't see how to log into postgres as that user. If you could run the "create extension postgis" SQL, that would be good. Link to comment Share on other sites More sharing options...
Krydos Posted July 18, 2018 Share Posted July 18, 2018 Postgis extension has been created on the database alank_backloader. Link to comment Share on other sites More sharing options...
alank Posted July 21, 2018 Author Share Posted July 21, 2018 Thank you. Is it possible to enable remote access to "alank_backloader" for postgres user "alank_backloader"? Link to comment Share on other sites More sharing options...
Krydos Posted July 22, 2018 Share Posted July 22, 2018 Remote access enabled. Link to comment Share on other sites More sharing options...
Recommended Posts