How to delete a database in `Azure Database for PostgreSQL flexible server`?

Senad Hadzikic 20 Reputation points
2024-03-07T21:46:04.8633333+00:00

Trying to delete/drop a database in Azure Database for PostgreSQL flexible server but getting this error. The same error appears if I try using CLI.

Screenshot 2024-03-07 at 22.35.59

Azure
Azure
A cloud computing platform and infrastructure for building, deploying and managing applications and services through a worldwide network of Microsoft-managed datacenters.
910 questions
Azure Database for PostgreSQL
0 comments No comments
{count} votes

Accepted answer
  1. Rahul Randive 8,101 Reputation points Microsoft Employee
    2024-03-08T00:36:29.2133333+00:00

    Hi @Senad Hadzikic

    Hi Look like you are trying to delete default database. A postgres database is created under your server. The postgres database is a default database that's meant for use by users, utilities, and third-party applications. (The other default database is azure_maintenance. Its function is to separate the managed service processes from user actions). You can't access this database and it seems Deleting the default PostgreSQL database is not supported in Azure Database for PostgreSQL flexible server. You can only delete user-created databases.

    Hope this help!

    Thank You!


0 additional answers

Sort by: Most helpful