Azure PostgreSQL Flexible Server - Creating Database in pgAdmin tool

Karol IL 0 Reputation points
2024-05-28T12:25:39.03+00:00

Hi,

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

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Sreeju Nair 12,181 Reputation points
    2024-05-28T13:57:07.6+00:00

    Refer below

    User's image

    Refer: https://video2.skills-academy.com/en-us/azure/postgresql/flexible-server/concepts-security

    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.

    Refer: https://video2.skills-academy.com/en-us/azure/postgresql/flexible-server/how-to-connect-query-guide

    Hope this helps

    0 comments
  2. Vinodh247-1375 12,506 Reputation points
    2024-05-28T14:04:10.05+00:00

    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.

    https://video2.skills-academy.com/en-us/answers/questions/1183161/how-can-i-use-pg-default-tablespace-in-azure-postg

    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