PostgreSQL Single server to Flexible server fails on BYPASSRLS

Niels Delestinne 25 Reputation points
2024-10-16T14:53:30.6633333+00:00

Hello,

We're using the Azure Database Migration service to migrate our Azure PostgreSQL Single server to a Flexible server.

It fails with the following message: "Failed to execute query `ALTER ROLE "dummyAdmin" WITH BYPASSRLS;` with error : 42501: must be superuser to change bypassrls attribute"

What is happening here? Any insights?

  • Shouldn't the migration service avoid re-creating / altering the "dummyAdmin"?
  • How can we resolve this issue?
  • Important: we performed similar and even identical (test) migrations a few days ago, and the service did not fail whatsoever (see screenshot)

azure_migration1

azure_migration2

Some more details:

  • Offline method
  • Tried via the portal and via the cli
  • The migration consists of multiple databases, but the postgres database is never selected.
  • We've created the Flexible server via an ARM template (with "dummyAdmin" as the administratorLogin), and it gets created successfully (beforehand).
  • "dummyAdmin" exists on both the single server as on the flexible server (via administratorLogin created). However, on the single server, "dummyAdmin" has NOBYPASSRLS configured, while on the flexible server "dummyAdmin" has BYPASSRLS configured.
  • We get the error for each database we migrate (so the error message contains the error n-times, for each database once), so it seems to try and alter the role for each database?
Azure Database Migration service
Azure Database for PostgreSQL
{count} votes

Accepted answer
  1. Akeem Gbadebo 90 Reputation points
    2024-10-17T17:19:20.5+00:00

    Hi Neils,

    I think the changes made was reverted. Please try to reproduce the issue from your end again.

    1 person found this answer helpful.

0 additional answers

Sort by: Most helpful

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.