systemcr Posted December 31, 2019 Share 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 Link to comment Share on other sites More sharing options...
wolstech Posted December 31, 2019 Share 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. Link to comment Share on other sites More sharing options...
systemcr Posted December 31, 2019 Author Share 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 Link to comment Share on other sites More sharing options...
systemcr Posted January 3, 2020 Author Share 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! Link to comment Share on other sites More sharing options...
Sn1F3rt Posted January 3, 2020 Share 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. Link to comment Share on other sites More sharing options...
systemcr Posted January 3, 2020 Author Share 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 Link to comment Share on other sites More sharing options...
Krydos Posted January 3, 2020 Share Posted January 3, 2020 Other people have managed to create schemas on their own. I always assumed they did it through phppgadmin perhaps? Link to comment Share on other sites More sharing options...
systemcr Posted January 3, 2020 Author Share 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. Link to comment Share on other sites More sharing options...
wolstech Posted January 3, 2020 Share 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. Link to comment Share on other sites More sharing options...
systemcr Posted January 4, 2020 Author Share 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 Link to comment Share on other sites More sharing options...
systemcr Posted January 4, 2020 Author Share 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. :-) Link to comment Share on other sites More sharing options...
Recommended Posts