Horus

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_statisticsgbanhudo_gazeteerSchemas: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

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!

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

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

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

@Krydos - Let me know if you can't fix it. Its not a problem, it was a mess anyway, its the perfect excuse to rebuild it.

Thank you for your reply. The user is: ***********

Thank you for the move, however it seems something went wrong. My database lost an entire schema named WOF (the only one which had content). Can this be looked into?

Next time, make a direct forum post. It won't show usernames/domains. I'm sure when a root admin sees this, they will verify it for you and remove offending tidbits. You are absolutely right, my bad! I just saw other people do it so I figured I should do the same eheh! Hopefully next month I can donate again and I'll create the appropriate thread.

On a side note, do be so kind so as to remove my username/domain from the post for privacy reasons

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