Azure PostgreSQL Flexible Server - Creating Database in pgAdmin tool

Karol IL 0 Reputation points


I am using Azure Database for PostgreSQL Flexible Servers, I cannot create database in pgAdmin due to missing privileges for pg_default tablespace.

I cannot find that in documentation, could you confirm that creating databases are possible only in Azure Portal / CLI / PS but not via SQL script?

Azure Database for PostgreSQL
{count} votes

2 answers

Sort by: Most helpful
  1. Sreeju Nair 12,026 Reputation points

    Refer below

    User's image


    There is no restriction on connecting to Azure Database for PostgreSQL Flexible Server using tools like psql or pgAdmin. These tools can be used to connect to the server and manage existing databases, run queries, and perform various database operations.


    Hope this helps

    0 comments No comments

  2. Vinodh247-1375 12,146 Reputation points

    Hi Karol IL,

    Thanks for reaching out to Microsoft Q&A.

    Looks like a known issue. See the below answer from 'GeethaThatipatri-MSFT' and the links as well.

    Let us know if this is what you are looking for.

    Please 'Upvote'(Thumbs-up) and 'Accept' as an answer if the reply was helpful. This will benefit other community members who face the same issue.

    0 comments No comments