Live migration to CosmosDB for PostgresQL

Thomas Støa Pettersen 1 Reputation point
2022-12-13T11:09:52.127+00:00

It's my understanding that the DB Migration service does not support CosmosDb for Postgresql.

What is the recommended way of migrating an existing DB to Azure CosmosDb for Postgresql?

I've been looking into setting up replication manually, but I'm unsure it it's possible with CosmosDB?

I have a couple of TB of data I need to get move, and taking the database offline for several hours isn't a good option for me.

Should I migrate into flexible server first, and then perhaps setup read-replication to cosmosdb? Is that supported by the tools Azure offers?

Azure Database Migration service
Azure Cosmos DB
Azure Cosmos DB
An Azure NoSQL database service for app development.
1,763 questions
Azure Database for PostgreSQL
{count} votes

1 answer

Sort by: Most helpful
  1. GeethaThatipatri-MSFT 29,517 Reputation points Microsoft Employee
    2022-12-16T17:54:06.937+00:00

    Hi, @ThomasStaPettersen-9231 Welcome to the Microsoft Q&A forum, Thanks for posting your question.
    I've been looking into setting up replication manually, but I'm unsure it it's possible with CosmosDB? -
    There is no option to set Azure Cosmos DB for PostgreSQL as a replication target

    I have a couple of TB of data I need to get move, and taking the database offline for several hours isn't a good option for me. -
    You can check pgcopydb: Copy a Postgres database to a target Postgres server (pg_dump | pg_restore on steroids) (github.com), https://github.com/dimitri/pgcopydb

    Should I migrate into flexible server first, and then perhaps setup read-replication to cosmosdb? Is that supported by the tools Azure offers? -
    We currently have no automated migration path from the Flexible server to Azure CosmosDB for PostgreSQL

    Hope this will help. Please let us know if any further queries.

    Regards
    Geetha

    Please don't forget to click on 130616-image.png or upvote 130671-image.png button whenever the information provided helps you. Original posters help the community find answers faster by identifying the correct answer.


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.