[Solved] REMOTE CONNECTION TO POSTGRESQL

[rgdepaula]

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]

This support request is being escalated to our root admins.

[Krydos]

Remote access enabled.

host=65.19.141.77
port=5432
username=rodrigodepaula_admin
dbname=rodrigodepaula_cursosgis
password=<what you typed into Plesk>

 

[rgdepaula]

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]

You're trying to connect to the database postgres. You need to connect to rodrigodepaula_cursosgis instead.

[rgdepaula]

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]

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.