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.
How do I fix a "permission denied for schema public" error in my dev database?
Validated on 4 Nov 2025 • Last edited on 5 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, delete the existing dev database and create a new one, ensuring the app deploys successfully.
Related Topics
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.
How do I fix an "Image or digest not found" error with multiple registries?
Specify the registry property in the app spec.