App Platform does not support backups, but you can use DigitalOcean Managed Databases to back up your data.
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.
Related Topics
Increase the heap memory by setting the environment variable NODE_OPTIONS=–max-old-space-size=4096.
You cannot add the same domain name to multiple apps or split an app and domain name across more than one account.