Azure Database for PostgreSQL Single Server documentation

Azure Database for PostgreSQL is a relational database service based on the open-source Postgres database engine. Single server is one of the various deployment options to create a postgres server. Learn how to use Single Server with our quickstarts, tutorials, and samples.

About Single Server

Overview

• What is Single Server?

What's new

• Check out our blog

Get started

Quickstart

• Create a server using the Azure Portal
• Create a server using Azure CLI

Training

• Learning module: Create an Azure Database for PostgreSQL server

Concept

• Pricing tiers
• Limits
• PostgreSQL versions
• PostgreSQL extensions - single server

Tutorial

• Design a Database on Single Server
• Build a Web App using Python (Django)

Connect and query

Concept

• Understand the firewall

How-To Guide

• Create firewall rules
• Configure TLS

Get Started

• Connect using Python
• Connect using Node.js
• Connect using Java
• Connect using Ruby
• Connect using PHP
• Connect using .Net
• Connect using Go

Manage and migrate

Concept

• Understand Virtual Networks
• Monitor and tune the service

How-To Guide

• Migrate a database using pg_dump and pg_restore
• Migrate a database using pg_dump and psql
• Migrate using Data Migration Service

Business Continuity

Concept

• Business continuity
• Back up and restore

How-To Guide

• Create a read replica
• Restore a server

Reference

Get Started

• Azure CLI scripts for common tasks

Reference

• Azure CLI developer reference
• REST API developer reference
• Azure Resource Manager templates