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

Cadalt 0 Reputation points
2024-10-02T18:38:52.33+00:00

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

Azure Database for PostgreSQL
0 comments No comments
{count} votes

2 answers

Sort by: Most helpful
  1. Amira Bedhiafi 24,376 Reputation points
    2024-10-02T20:00:28.88+00:00

    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.
    1. 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.
    1. 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.

    1. 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.

    0 comments No comments

  2. RahulRandive 9,666 Reputation points
    2024-10-03T01:56:08.2+00:00

    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://video2.skills-academy.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!

    0 comments No comments

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.