Can't we reduce the postgres storage once upgraded ?

Question

Can't we reduce the postgres storage once upgraded ?

ReCloudS 80

12 Mar 2025, 06:07

Hello ,

I have an postgres deployed on my azure env but from the past couple of months we have been facing storage issues hence we are trying to downgrade the storage as we fixed the code and but I don't see the option of previous storage like earlier 64GiB later upgraded to 128GiB and now 256GiB but now I want to take it back to 128GiB, it is how it is ? or can we downgrade ?

1 answer

Your answer

Answer 1

Deepanshu katara 14,580 MVP

12 Mar 2025, 06:15

Hello , Welcome to MS Q&A

You cannot downgrade the storage size of your PostgreSQL database on Azure. Once the storage size is increased, it cannot be reduced. To achieve a smaller storage size, you would need to create a new Azure Database for PostgreSQL flexible server instance with the desired storage size and then perform a manual dump and restore operation to migrate your databases.

For more details, you can refer to the Limits in Azure Database for PostgreSQL flexible server and the steps to scale storage

Please let me know if any ques

Kindly accept if it helps

Thanks

Deepanshu

Mallaiah Sangi 175 Reputation points Microsoft External Staff

13 Mar 2025, 01:26

Hi ReCloudS •

Just checking in to see if the above answers provided @Deepanshu katara helped.

If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.
Mallaiah Sangi 175 Reputation points Microsoft External Staff

17 Mar 2025, 01:50

Hi ReCloudS

We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. In case if you have any resolution please do share that same with the community as it can be helpful to others. Otherwise, will respond with more details and we will try to help.

Share via

Can't we reduce the postgres storage once upgraded ?

1 answer

Your answer