Quickstart: Create an Azure Database for PostgreSQL server by using the Azure portal
APPLIES TO: Azure Database for PostgreSQL - Single Server
Azure Database for PostgreSQL - Single Server is on the retirement path. We strongly recommend for you to upgrade to Azure Database for PostgreSQL - Flexible Server. For more information about migrating to Azure Database for PostgreSQL - Flexible Server, see What's happening to Azure Database for PostgreSQL Single Server?
Azure Database for PostgreSQL is a managed service that you use to run, manage, and scale highly available PostgreSQL databases in the cloud. This quickstart shows you how to create a single Azure Database for PostgreSQL server and connect to it.
An Azure subscription is required. If you don't have an Azure subscription, create a free Azure account before you begin.
Create an Azure Database for PostgreSQL server
Go to the Azure portal to create an Azure Database for PostgreSQL Single Server database. Search for and select Azure Database for PostgreSQL servers.
Select + Create.
On the Create a Azure Database for PostgreSQL page , select Single server.
Now enter the Basics form with the following information.
Setting Suggested value Description Subscription your subscription name select the desired Azure Subscription. Resource group myresourcegroup A new or an existing resource group from your subscription. Server name mydemoserver A unique name that identifies your Azure Database for PostgreSQL server. The domain name postgres.database.azure.com is appended to the server name that you provide. The server can contain only lowercase letters, numbers, and the hyphen (-) character. It must contain 3 to 63 characters. Data source None Select None to create a new server from scratch. Select Backup only if you were restoring from a geo-backup of an existing server. Admin username myadmin Enter your server admin username. It can't start with pg_ and these values are not allowed: azure_superuser, azure_pg_admin, admin, administrator, root, guest, or public. Password your password A new password for the server admin user. It must contain 8 to 128 characters from three of the following categories: English uppercase letters, English lowercase letters, numbers (0 through 9), and non-alphanumeric characters (for example, !, $, #, %). Location your desired location Select a location from the dropdown list. Version The latest major version The latest PostgreSQL major version, unless you have specific requirements otherwise. Compute + storage use the defaults The default pricing tier is General Purpose with 4 vCores and 100 GB storage. Backup retention is set to 7 days with Geographically Redundant backup option.
Learn about the pricing and update the defaults if needed.
Consider using the Basic pricing tier if light compute and I/O are adequate for your workload. Note that servers created in the Basic pricing tier can't later be scaled to General Purpose or Memory Optimized.
Select Review + create to review your selections. Select Create to provision the server. This operation might take a few minutes.
An empty database, postgres, is created. You'll also find an azure_maintenance database that's used to separate the managed service processes from user actions. You can't access the azure_maintenance database.
Configure a firewall rule
By default, the server that you create is not publicly accessible. You need to give permissions to your IP address. Go to your server resource in the Azure portal and select Connection security from left-side menu for your server resource. If you're not sure how to find your resource, see Open resources.
Select Add current client IP address, and then select Save. You can add more IP addresses or provide an IP range to connect to your server from those IP addresses. For more information, see Firewall rules in Azure Database for PostgreSQL.
To avoid connectivity issues, check if your network allows outbound traffic over port 5432. Azure Database for PostgreSQL uses that port.
Connect to the server with psql
Make a note of your server name, server admin login name, password, and subscription ID for your newly created server from the Overview section of your server.
Open Azure Cloud Shell in the portal by selecting the icon on the upper-left side.
If you're opening Cloud Shell for the first time, you'll see a prompt to create a resource group and a storage account. This is a one-time step and will be automatically attached for all sessions.
Run the following command in the Azure Cloud Shell terminal. Replace values with your actual server name and admin user login name. Use the empty database postgres with admin user in this format:
psql --host=mydemoserver.postgres.database.azure.com --port=5432 --username=myadmin@mydemoserver --dbname=postgres
Here's how the experience looks in the Cloud Shell terminal:
Requesting a Cloud Shell.Succeeded. Connecting terminal... Welcome to Azure Cloud Shell Type "az" to use Azure CLI Type "help" to learn about Cloud Shell user@Azure:~$psql --host=mydemoserver.postgres.database.azure.com --port=5432 --username=myadmin@mydemoserver --dbname=postgres Password for user firstname.lastname@example.org: psql (12.2 (Ubuntu 12.2-2.pgdg16.04+1), server 11.6) SSL connection (protocol: TLSv1.2, cipher: ECDHE-RSA-AES256-GCM-SHA384, bits: 256, compression: off) Type "help" for help. postgres=>
In the same Azure Cloud Shell terminal, create a database called guest.
postgres=> CREATE DATABASE guest;
Switch connections to the newly created guest database.
\q, and then select the Enter key to close psql.
Clean up resources
You've successfully created an Azure Database for PostgreSQL server in a resource group. If you don't expect to need these resources in the future, you can delete them by deleting either the resource group or the PostgreSQL server.
To delete the resource group:
- In the Azure portal, search for and select Resource groups.
- In the resource group list, choose the name of your resource group.
- On the Overview page of your resource group, select Delete resource group.
- In the confirmation dialog box, enter the name of your resource group, and then select Delete.
To delete the server, select the Delete button on the Overview page of your server: