Azure PostgreSQL
PostgreSQL is a fully managed relational database service based on the popular open-source PostgreSQL database engine. It provides high availability, scalability and security for data. Azure PostgreSQL is ideal for:
- storing structured data
- running transactional workloads
- building applications that require relational databases
- managing data for web applications
The Federal Science DataHub (FSDH) allows users to provision Azure PostgreSQL for research, enabling them to store and manage data in a secure and scalable environment.
Sample use case
Researchers at Environment and Climate Change Canada use Azure PostgreSQL to store data about air pollution mixtures relevant to Canadians living in urban areas. The FSDH provides them with a secure and scalable environment to manage their data and run queries for analysis.