Share via

We are trying to migrate a on-prem postgresql server(12.2) to a flexible server(16)

snehil kaushik 0 Reputation points
2025-08-11T15:49:37.9166667+00:00

We are trying to migrate the on-prem postgresql server in master-slave config to a flexible server using the migrate option within the flexible server.

I am getting error, permission denied for function pg_replication_origin_oid.. replicate slot was created by azure using pgoutput.

Sometimes I get error that it is unable to create the slot and migrate fail while the table are queued.

I tried in my test environment by creating a vm on azure and installing the postgresql 12.2 on it and migration works smoothly.

Any idea what I am missing ?

Azure Database for PostgreSQL

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.