how to create postgresql when I have student dev pack sub.

Question

So I tried creating db from student dev pack but it not allowing kind off , asking for some data while creating where i cant select beacuse nothing available to select

Answer 1

Hi @Cadalt

With an Azure free account, you can use Azure Database for PostgreSQL flexible server for free for 12 months with monthly limits of up to:

• 750 hours of Burstable B1MS instance, enough hours to run a database instance continuously each month.
• 32 GB storage and 32 GB backup storage.

Make sure you do not exceed the above limit. Also, please find Prerequisites to create Azure Database for PostgreSQL flexible server instance in below document

https://learn.microsoft.com/en-us/azure/postgresql/flexible-server/how-to-deploy-on-azure-free-account#prerequisites

While creating the Azure Database for PostgreSQL flexible server instance from your Azure free account, you still see an Estimated cost per month in the Compute + Storage : Cost Summary blade and Review + Create tab. But, as long as you are using your Azure free account, and your free service usage is within monthly limits (to view usage information, refer Monitor and track free services usage section below), you won't be charged for the service.

Feel free to share screenshot about the experience/error you are getting on the portal.

Thank You!

Answer 2

Here are some steps to help guide you through this process:1. Check if PostgreSQL is Available in Your Subscription

First, ensure that your Azure Student Dev subscription includes the PostgreSQL service. Sometimes, specific tiers or services might not be available in certain subscription types. To check:

• Go to the Azure Portal.
• Navigate to Create a resource.
• Search for Azure Database for PostgreSQL.
• If it appears, then PostgreSQL is available for your subscription. If not, you may need to upgrade your subscription or reach out to Azure support.

2. Follow the Creation Process

To create a PostgreSQL database:

• In the Azure Portal, click Create a resource and search for Azure Database for PostgreSQL.
• Select the Flexible Server or Single Server deployment option (Flexible Server is recommended for new setups).
• Fill in the required fields such as Server Name, Location, Version, Compute + Storage, and Authentication Method.

3. Troubleshooting: Data Not Available to Select

If you are seeing that some fields in the creation form are not showing any options or are greyed out:

Region: Make sure you're selecting a valid Region where Azure Database for PostgreSQL is available. Not all regions support all services.

Compute Tier or Version: Ensure you are choosing supported values based on the region you selected.

If you're unable to select certain options, it could be due to the limitations of the Student Dev subscription. You might not have access to certain high-tiered or advanced options. Try using the Basic compute tier or lower specs for initial setup.

4. Verify Your Dev Pack Benefits

Make sure your Azure Student Dev Pack is fully activated and that you're within the limits of the available free credits:

• Check your available services and quota through the Azure Subscription panel.
• You may have to manage resources like compute and storage sizes within the limits of the Dev Pack to avoid the issue.

If everything seems correct, but you’re still unable to proceed, I recommend reaching out to Azure Support. They can verify whether your subscription type has restrictions that could be causing this issue.