Horus

I’ll see what our root admin has to say about this.

 

Escalating

I just noticed a typo, its PostGIS not PostgreSQL which needs to be updated. Any news on this subject? This renders PostGIS from JSON useless.

Requesting remote access to PostgreSQL database.

Users: gbanhudo_remoteuser , gbanhudo_admin

DB: gbanhudo_website

Thanks in advance!

Is it possible to update PostgreSQL? Unfortunately the 2.3 version seems to have been compiled without JSON-C, hence using JSON generates errors.

And a happy new year!

Thank you both for your attention.

Its two databases: ***** and ****.

Thank you!

Is it possible to install PostgreSQL's PostGIS extension?

I would like to request access to the following databases & schemas for the user "gbanhudo_remoteuser":

• Databases:
  • gbanhudo_statistics
  • gbanhudo_gazeteer
• Schemas:
  • gbanhudo_geometries.wof (though the access to the DB has already been granted in this thread, access for the schemas must be given by hand)

As for the schema, here lies an example of the problem. The solution then consists of employing the following:

GRANT ALL PRIVILEGES ON ALL TABLES IN SCHEMA wof TO gbanhudo_remoteuser;

Thanks in advance and sorry for the extra work

This support request is being escalated to our root admin.

You can grant postgresql permissions yourself through the button labeled PostgreSQL Databases in cPanel.

Unfortunately this is not true for Schemas, as for some reason custom schemas other than public reflect in unauthorized remote access. Here is an example on this situation. Is my alternative using the public schema?

I have been granted remove access to my database. However, it seems the permission also needs to be granted on the schemas as I am not able to access them.

Database: gbanhudo@geometries

User: gbanhudo_remoteuser

Schemas: - public

                 - wof

Thank you!

Remote access enabled.

Thank you Krydos. However, psycopg2 (Python) is still unable to connect. Can you double check?

Not that actually. I didn't ask your username. I meant the Database user, you'd like remote access to be enabled for.

 

Example:

gbanhudo_test

 

Replace 'test' with the user you've created.

My bad, the user is "*****_remoteuser"

Please mention the user, you'd like to Grant remote access to, in name.

 

Krydos can set that up for you.

Thank you for your reply. It was already there, I edited the post to make it more visible.

From what I've been reading in similar threads, external access to a DB (in my case, for inflating data onto a DB programatically) has to be requested.

With this in mind, I am then requesting remote access to the 

*****_geometries

 database, belonging to user:

*****

_remoteuser

I believe that the Best for beginners is in fact Ubuntu,yet,Red Hat and Fedora are awesome (not for newbies though) !

Nice,I found some cool Addons thanks to this post ! Yet,my favourites are still : ForeCastFox;ChatZilla;VideoDownloader;Download Accelarator Plus !.

I hope you enjoy these