Azure Postgres Migrattion steps not clear

[rhuesken]

I'm trying to follow this guide in order to migrate an entire (Azure Postgres flexible) server, with multiple databases and multiple schema's in each database. I also need to migrate several roles from the source database.

Step1 and 3 (use pg_dump to create and restore a schema for a database) are not clear.

1. Which user should be passed to this pg_dump command?
2. The option -o is not supported by pg_dump (PG13). I assumed this is should be -O (capital letter). Is that correct?
3. The pg_dump -O option does not set ownership when recreating the objects in the target database. How will object ownerschip be restored?
4. Using the pg_dump -O option results in statements that set priviliges for roles, yet no create role commands are included in the script. What are the prerequisites to migrate roles too?

Also please describe the expected result of "Migrate Sample schema step". This will allow me to achieve this result in an alternative way, and safely proceed with subsequent steps.

---

Document Details

⚠ Do not edit this section. It is required for learn.microsoft.com ➟ GitHub issue linking.

• ID: 00403cac-9788-3966-2c23-696748b9379b
• Version Independent ID: db980aa3-68e9-98d0-724c-030ab3fd68ff
• Content: Tutorial: Migrate Azure DB for PostgreSQL to Azure DB for PostgreSQL online via the Azure portal - Azure Database Migration Service
• Content Source: articles/dms/tutorial-azure-postgresql-to-azure-postgresql-online-portal.md
• Service: dms
• GitHub Login: @croblesm
• Microsoft Alias: roblescarlos

[SaibabaBalapur-MSFT]

@rhuesken Thanks for your feedback! We will investigate and update as appropriate.

[shaktisingh-msft]

Hi @croblesm,

Could you please look into this documentation enhancement request.

[croblesm]

Hey @adityaduvuri_microsoft, let's work on this issue together.

[SaibabaBalapur-MSFT]

I have reassigned case to @croblesm

@adityaduvuri_microsoft Please can you help me with your Github user ID, so we can assign case to you, Thanks you.

[croblesm]

Here you have Aditya's ID: @apduvuri

[rwestMSFT]

This question is more than 18 months old, with no activity, so I am closing it. If you feel that your question still should be answered, please either open a Support request, or use the Feedback option on the article in question. GitHub issues for azure-docs will be disabled in the near future.

please-close