Freezing Database resource to save money and time

Category: azure database for postgresql


conterio on Wed, 21 Mar 2018 23:45:14

I created a Database for PostgresSQL at a higher priced tier for testing purposes.  I moved over all my data over to the DB and have done my testing.  I would like to do some additiona testing later on in the future but I don't want to have to delete the resource and re created it when i'm ready to test again.

I was wondering if there was a way I could freeze the resource (so i'm not paying for it) and then unfreeze it when i'm ready to do the testing again.  Normally you can upgrade the tier at anytime but they have not yet support this feature for db for PostgresSQL.




Nik Larin--MSFT on Thu, 22 Mar 2018 01:14:20

@conterio you can backup your database(s) using any backup tool that supports PG such as pg_dump, delete your instance of Azure Database for PostgreSQL and then, when you'd like to get back to your testing, create a new one and use pg_restore against the new instance. This is currently the only way to stop paying. 

We're assessing interest in 'Pause compute' feature for our service but don't have any specific plans for it. Please note that even if/when we have 'Pause compute' feature implemented you'd still have to pay for storage. 

I hope it helps.