rgdepaula Posted January 14 Share Posted January 14 Hi guys, I need remote access to the PostgreSQL from any ip. Server: tommy2.heliohost.org Postgresql user: rodrigodepaula_admin Postgresql database: rodrigodepaula_cursosgis Best regards, Rodrigo. Link to comment Share on other sites More sharing options...
MoneyBroz Posted January 14 Share Posted January 14 This support request is being escalated to our root admins. Link to comment Share on other sites More sharing options...
Krydos Posted January 15 Share Posted January 15 Remote access enabled. host=65.19.141.77 port=5432 username=rodrigodepaula_admin dbname=rodrigodepaula_cursosgis password=<what you typed into Plesk> Link to comment Share on other sites More sharing options...
rgdepaula Posted January 15 Author Share Posted January 15 Thank you very much. I can't connect database on Pgadmin and I don't know why. See attached the fatal error. If a change "Maintenance database" field for my dbname, I can connect, but can't create a postgis extension because my user is not superuser. Could you help me? Best regards. Link to comment Share on other sites More sharing options...
Krydos Posted January 15 Share Posted January 15 You're trying to connect to the database postgres. You need to connect to rodrigodepaula_cursosgis instead. Link to comment Share on other sites More sharing options...
rgdepaula Posted January 16 Author Share Posted January 16 Thanks for your help. A can't create a postgis extension in my db rodrigodepaula_cursosgis. Please, see the image attached. The message tell me that i need to superuser in my data base. What am I not doing? Link to comment Share on other sites More sharing options...
Krydos Posted January 16 Share Posted January 16 Creating extensions requires super user privileges. Viewing and deleting other people's databases also requires super user privilege. If we gave you the ability to create extensions yourself you would also be able to see other people's databases or even drop them therefore if you need an extension created you either need to get a VPS where you have root access to run whatever command you want and there are no other users on your server, or request an admin to create the extension for you. The extension postgis has been created on the rodrigodepaula_cursosgis database for you. Link to comment Share on other sites More sharing options...
Recommended Posts