How do I fix a "permission denied for schema public" error in my dev database?

Validated on 4 Nov 2025 • Last edited on 26 Nov 2025

In an App Platform dev database, an ERROR: permission denied for schema public error usually happens when the app’s deployment fails.

During the deployment process, App Platform grants the dev database user the necessary permissions to access the public schema. However, if the deployment fails, the user does not receive the permissions, resulting in the error. This can also cause the database to become stuck on connection string is being provisioned.

To resolve this issue, first delete the existing dev database and deploy the app, ensuring the deployment completes successfully. Then create a new dev database and deploy the app again, making sure the deployment is successful.

How do I back up my app on App Platform?

App Platform does not support backups, but you can use DigitalOcean Managed Databases to back up your data.

Why do I get the error “JavaScript heap out of memory” during deployment?

Increase the heap memory by setting the environment variable NODE_OPTIONS=–max-old-space-size=4096.

Why do I get the error "Domain Already Exists" when trying to add a domain to an app in another account?

You cannot add the same domain name to multiple apps or split an app and domain name across more than one account.

We can't find any results for your search.

Try using different keywords or simplifying your search terms.