[Krydos] error - CREATE EXTENSION postgis

[camilogeo]

[wolstech]

Creating the postgis extension is not something you can do yourself. Krydos has to do this for you.

What is the name of the database that needs this extension?

[camilogeo]

server: johnny.heliohost.org

Postgresql user: "camilogeo_admin"

Postgresql database: "camilogeo_gis"

[wolstech]

Krydos can create postgis on it for you. Escalating.

[Krydos]

Johnny doesn't support PostGIS because he's too old. Same with Tommy. Right now only Morty and VPS plans support PostGIS. If you'd like to make sure Morty can do what you need we can give you a week trial, and if everything works the way you want you can make a payment to stay on that server. We will be upgrading Tommy and Johnny to support PostGIS too, but it may be a few months out still.

[camilogeo]

I would like to have the one-week trial access to test it. I want to use it for academic purposes, which includes uploading vector and raster data, working on maps with a team in QGIS, and creating user permissions.

[Krydos]

You're being moved to Morty. Your trial will end on 2025-08-26.

The postgis extension has been created on the camilogeo_gis database.

[camilogeo]

 

[Krydos]

I can't read that language. Let us know if there is something we can help you with.

[camilogeo]

Request to allow database access from any IP address

Hello,

I am trying to connect to the PostGIS database on the server morty.heliohost.org, but my connection is being blocked by the pg_hba.conf settings.

To facilitate access for testing purposes, could you please change the rule in the pg_hba.conf file to allow connections to my database from any IP address?

Details:

• Server: morty.heliohost.org

• Database: camilogeo_gis

• User: camilogeo_admin

The required permission lines in pg_hba.conf should be changed to:

# For IPv4
host    camilogeo_gis   camilogeo_admin   0.0.0.0/0   md5

# For IPv6
host    camilogeo_gis   camilogeo_admin   ::/0        md5

I am aware of the security risks associated with this configuration.

Thank you for your help.

 

Edited 1 hour ago by camilogeo

[Krydos]

Remote access was already enabled for that database, and the remote access was transferred to Morty when your account was moved. The problem is you're using the host "morty.heliohost.org" and you should be using the host "65.19.154.94". Thanks for translating it to English for me.

host=65.19.154.94
port=5432
user=camilogeo_admin
dbname=camilogeo_gis
password=<set in Plesk>