Events
Nov 14, 11 PM - Feb 9, 11 PM
The Call-for-Proposals is open until February 9 for this free and virtual developer event.
Get startedThis browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
APPLIES TO: Azure Database for PostgreSQL - Flexible Server
This article provides considerations and guidelines for working with Azure Database for PostgreSQL flexible server.
A server in the Azure Database for PostgreSQL flexible server deployment option is a central administrative point for multiple databases. It's the same PostgreSQL server construct that you might be familiar with in the on-premises world. Specifically, Azure Database for PostgreSQL flexible server is managed, provides performance guarantees, and exposes access and features at the server level.
An Azure Database for PostgreSQL flexible server instance:
Within an Azure Database for PostgreSQL flexible server instance, you can create one or multiple databases. You can opt to create a single database per server to utilize all the resources, or create multiple databases to share the resources. The pricing is structured per-server, based on the configuration of pricing tier, vCores, and storage (GB). For more information, see Compute options.
The following elements help ensure safe access to your database:
Security concept | Description |
---|---|
Authentication and authorization | Azure Database for PostgreSQL flexible server supports native PostgreSQL authentication. You can connect and authenticate to a server by using the server's admin login. |
Protocol | The service supports a message-based protocol that PostgreSQL uses. |
TCP/IP | The protocol is supported over TCP/IP and over Unix-domain sockets. |
Firewall | To help protect your data, a firewall rule prevents all access to your server and to its databases until you specify which computers have permission. See Azure Database for PostgreSQL flexible server firewall rules. |
You can manage Azure Database for PostgreSQL flexible server instances by using the Azure portal or the Azure CLI.
When you create a server, you set up the credentials for your admin user. The admin user is the highest-privilege user on the server. It belongs to the role azure_pg_admin. This role does not have full superuser permissions.
The PostgreSQL superuser attribute is assigned to azure_superuser, which belongs to the managed service. You don't have access to this role.
An Azure Database for PostgreSQL flexible server instance has default databases:
The Azure Database for PostgreSQL flexible server parameters determine the configuration of the server. In Azure Database for PostgreSQL flexible server, you can view and edit the list of parameters by using the Azure portal or the Azure CLI.
As a managed service for Postgres, Azure Database for PostgreSQL has configurable parameters that are a subset of the parameters in a local Postgres instance. For more information on Postgres parameters, see the PostgreSQL documentation.
Your Azure Database for PostgreSQL flexible server instance is enabled with default values for each parameter on creation. The user can't configure some parameters that would require a server restart or superuser access for changes to take effect.
Events
Nov 14, 11 PM - Feb 9, 11 PM
The Call-for-Proposals is open until February 9 for this free and virtual developer event.
Get startedTraining
Learning path
Configure and migrate to Azure Database for PostgreSQL DP-3021 - Training
Azure Database for PostgreSQL is a Platform as a Service database service in the Microsoft cloud. It bases itself on the PostgreSQL open-source relational database and includes built-in high availability, automatic backup and restore, as well as comprehensive security features. The pay-as-you-go pricing model provides predictable performance and near-instant scaling. In this learning path, you're introduced to the main features of PostgreSQL and how they work in Azure Database for PostgreSQL. You learn abou
Certification
Microsoft Certified: Azure Database Administrator Associate - Certifications
Administer an SQL Server database infrastructure for cloud, on-premises and hybrid relational databases using the Microsoft PaaS relational database offerings.