systemcr Posted December 31, 2019 Posted December 31, 2019 (edited) Hi, I want to create a new schema on my PostgreSQL database but it seems I don't have enough permissions to do so (image attached). Can anyone tell me why? Thanks in advance! PD: by the way, it seems PostgreSQL's version on Johnny is 9.2, which is a bit old... could it be updated? Edited December 31, 2019 by systemcr
wolstech Posted December 31, 2019 Posted December 31, 2019 This one is a Krydos question. I don't know of too many if anyone who has tried to make additional schemas in PG here, simply because almost nobody uses PG here. The pg_cron question you had is also best answered by Krydos: https://www.helionet.org/index/topic/38190-pg-cron-for-postgresql/?do=findComment&comment=169411 though I've responded there as well with a few alternate solutions. You're one of the first to really exercise some technologies we offer (especially ASP.NET), so lots of things to fix and adapt As for version, I doubt it. We generally have to use whatever versions cPanel offers to avoid breaking cPanel.
systemcr Posted December 31, 2019 Author Posted December 31, 2019 (edited) Hi, No problem if the version can't be updated. However, not being able to create schemas is a big limitation in my opinion, as it helps a lot to keep database's objects well organized. It'd be great if we could create them. Edited December 31, 2019 by systemcr
systemcr Posted January 3, 2020 Author Posted January 3, 2020 Is Krydos on vacation? Just asking to get an idea about how long this answer can be delayed, as I can't continue working if I can't create schemas on my database. Thanks!
Sn1F3rt Posted January 3, 2020 Posted January 3, 2020 Well he seems a little busy, afterall The admins here are all volunteers, so they've they're RL problems as well. Whatever, hold on a little longer, he'll look into this issue.
systemcr Posted January 3, 2020 Author Posted January 3, 2020 (edited) Yes of course. I completely understand. Just asking to know if he wasn't here anymore Edited January 3, 2020 by systemcr
Krydos Posted January 3, 2020 Posted January 3, 2020 Other people have managed to create schemas on their own. I always assumed they did it through phppgadmin perhaps?
systemcr Posted January 3, 2020 Author Posted January 3, 2020 Hi, Thanks a lot for your response. Yes, I can create schemas from phppgadmin (I didn't know this tool did exist). However I think creating schemas from pgadmin should be possible. Kind regards.
wolstech Posted January 3, 2020 Posted January 3, 2020 If you're doing it over remote access with pgadmin, that's probably the reason. I suspect there's something else he needs to do for that to work.
systemcr Posted January 4, 2020 Author Posted January 4, 2020 (edited) Hi, I think it is more to grant access to the user I use to connect through pgAdmin to be able to use all of the objects in the database. I think I've done it from phppgadmin, but there're asterisks in the table of privileges after grating them whose meaning I don't understand: Screenshot: https://i.ibb.co/wsKJKJG/Screenshot-1.png I can't still work from pgadmin after this grant. I need to work from pgadmin because I can't be creating my database objects from a UI tool like the one provided by phppgadmin; I need to do this through SQL (I know, I can also run SQL from phppgadmin, but it's absolutely not the same working from a tool like pgAdmin). Edited January 4, 2020 by systemcr
systemcr Posted January 4, 2020 Author Posted January 4, 2020 Hi again, After some research, I've seen it's been a matter of granting access for the user I use to connect to my database at a schema level. After granting it access to my newly-created schema, I can work now from pgAdmin. :-)
Recommended Posts