permission denied for schema _timescaledb_internal on Azure PostgreSQL flexible server

Michiteru Sugitani 50 Reputation points
2024-04-17T11:08:26.95+00:00

I tried to migrate db from Azure PostgreSQL single server to flexible server using migration tool from Azure portal.
But there is an error on validation check because migration tool doesn't support timescaledb extension.
Portal message said that please use pg_dump and pg_restore.

So I did pg_dump and pg_restore for migration.
I did pg_restore as user pgsql_admin but I got an error "permission denied for schema _timescaledb_internal"
ChatGPT said for internal schema like _timescaledb_internal, it will need superuser privilege.
so I checked privilege for each users, and I realized only azuresu user has superuser privilege.
How to use azuresu user?
I know only credential for pgsql_admin user.

Best regards.
Michiteru

Azure Database for PostgreSQL
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. GeethaThatipatri-MSFT 27,417 Reputation points Microsoft Employee
    2024-04-17T16:10:03.45+00:00

    Hi, @Michiteru Sugitani Thanks for posting your question in the Microsoft Q&A forum.

    As per the document you can't move extensions not supported by the Azure Database for PostgreSQL – Flexible server. The supported extensions are in Extensions - Azure Database for PostgreSQL.

    https://learn.microsoft.com/en-us/azure/postgresql/migrate/migration-service/concepts-known-issues-migration-service

    User's image

    Please let me know if you have any additional questions.

    Regards

    Geetha