CODEWITHSUNDEEP
postgresqlazurepg-dumpazure-blob-storage
pookie
pookie

Reputation: 4142

Postgres pg_dump to Azure Blob storage

Is it possible to use Postgres' pg_dump to write the backup to an Azure Blob storage? I have almost 2TB of data on a VM in a postgres DB and I need to migrate all the data to a blob storage.

Upvotes: 6

Views: 3181

Answers (1)

Jay Gong
Jay Gong

Reputation: 23792

Per my experience , it's impossible to write data directly from Postgres DB to Azure Blob Storage currently.

You can refer to the following ways to implement your needs.

  1. As @4c74356b41 said in comment, you could dump your backup data to locally and move them to storage. Considering you have 2TB of data or even more, it's going to be a long process.

  2. You could create a data disk which is stored in Azure Blob Storage ,attach it to your vm , then you could write backup data to disk. More details , please view this page.

  3. Or you could use Azure Files with Linux or Windows , attach it to your vm via SMB. More details , please view this page.

Hope it helps you.

Upvotes: 2

Related Questions