Mysql and Postgresql datbases count

GemStoneGhost

• November 08, 2021 09:39

Hello, I have recently got Postgresql activated on my hosting service. The problem is that it is doubling the database number a customer may have in a single account. If I give 10 databases to a user, cPanel is displaying 10 databases for mysql and 10 for postresql. When mysql databases are consummed, their number decreases but not for postgresql. We have something like : mysql : 8 databases remaining and postgresql 10 databases. I think this behavior is not correct. Just as the same disk space is consuming by files, databases and emails, no matter, the databases count should also be consumed by both services the same way. If a give to a customer 10 databases, and they use 2 from mysql, both mysql and postgresql should only be able to have 8 databases remaining. If one of them consumes all 10 databases, the other should not be able to create any. Is this behavior configurable or are we condemned to use them that way ? Thank you much for your time.

• 

  andrew.n

  • November 08, 2021 14:53

  I believe this is the expected behaviour as pSQL and MySQL are different hence they have different limits. Some would only allow 1 pSQL and unlimited MySQL databases rather than a global limit and I think this is not configurable they way you wish at the moment but hopefully @cPanelAnthony will confirm this for us.

  0
• 

  cPanelAnthony

  • November 08, 2021 16:01

  Hello! The disk usage for PostgreSQL and MySQL are calculated separately by design. There's no way to configure it this way at this time, but I would urge you to submit a feature request using the link in my signature!

  0

Please sign in to leave a comment.