Question

Dev Database CREATE SCHEMA permission

Posted on April 24, 2025
Database Dev/Management
Asked by John Thorhauer

I am trying to us pgboss as part of my project. However the pgboss library needs to be able to create a schema. How can I solve this problem while using a Dev Database while I am building out my project? I tried granting the pvivilege to my user that that was denied. I also am not able to connect using the doadmin user.

Submit an answer

This textbox defaults to using Markdown to format your answer.

You can type !ref in this text area to quickly search our full set of tutorials, documentation & marketplace offerings and insert the link!

These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.

Bobby Iliev

Site Moderator

• April 28, 2025

Hi there,

I answered a similar question a few months ago here:

https://www.digitalocean.com/community/questions/how-to-create-tables-with-app-platform-managed-dev-databases

The issue is that Dev Databases don’t allow creating new databases or schemas, you have to use the default database and the public schema.

If you need to create your own extra schemas, it’s better to spin up a full Managed Database cluster instead of a Dev Database. That way, you’ll have full rights to create as many schemas as you need.