rgdepaula Posted January 14 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.
MoneyBroz Posted January 14 Posted January 14 This support request is being escalated to our root admins.
Krydos Posted January 15 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>
rgdepaula Posted January 15 Author 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.
Krydos Posted January 15 Posted January 15 You're trying to connect to the database postgres. You need to connect to rodrigodepaula_cursosgis instead.
rgdepaula Posted January 16 Author 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?
Krydos Posted January 16 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.
Recommended Posts