cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Show  only  | Search instead for 
Did you mean: 
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Azure Database for PostgreSQL
Copied!
Home
Options
1,091

Take your spatial data analysis to the next level with PostGIS at Azure PostgreSQL

tjukanov on 01-23-2020 09:26 AM
Your PostgreSQL database might have spatial data in it .You just might not know it yet. PostGIS, which is an open source...
413

Azure Database for PostgreSQL - Checklist for Performance

narenan on 01-22-2020 09:05 AM
Performance can often be improved by doing basic troubleshooting and by setting best practices in advance.
630

Using Private Link and Point-to-Site Gateway for secure on-premise connectivity to PostgreSQL Server

ramkychan on 01-14-2020 11:46 AM
In this blog post, we will outline detailed steps on how to connect securely from an On-Premise VM to Azure Database for...
1,862

Introducing Azure Active Directory authentication for Azure Database for PostgreSQL

LukasFittl on 12-17-2019 10:00 AM
We’re excited to announce the Public Preview of the Azure AD integration for Azure Database for PostgreSQL.
1,521

Using the Heimdall Proxy to Split Reads and Writes for Azure Databases

Roland Lee on 12-12-2019 09:05 AM
A write-master with read replicas are used to efficiently distribute SQL traffic. This requires costly application chang...
851

Accelerate SQL Performance with the Heimdall Proxy

Roland Lee on 12-10-2019 10:35 AM
If you are a developer or DBA, a database proxy can save you significant time and costs to improve SQL performance, all ...
488

Restore your Azure Database for PostgreSQL server into a different Azure subscription, the right way

Parikshit Savjani on 12-09-2019 07:56 PM
A challenge our customers often encounter is the inability to restore production databases across different Azure subscr...
1,143

Application state – I want the easiest, most trouble-free deployment for the database

bshetti on 12-05-2019 09:32 AM
As more and more applications convert to cloud native with Kubernetes as a normalizing layer, the ability to have portab...
816

How Data Virtualization is making the world of data more peaceful, productive, and profitable

mbolz on 12-03-2019 02:26 PM
Data is quite possibly the world’s most valuable resource. Recent assertions kicked off a debate about whether data is e...
814

Copy data from Azure Blob to Azure Database for PostgreSQL using Azure Data Factory

ramkychan on 11-20-2019 11:36 AM
Copy data from Azure Blob to Azure Database for PostgreSQL using Azure Data Factory
2,802

Azure Database for PostgreSQL - Hyperscale (Citus) now generally available

craigkerstiens on 11-19-2019 08:26 AM
Relational databases have been around since the dawn of time, well not quite that long, but it has been a long time for ...
936

Azure Database for PostgreSQL and OSSDBs on Azure: Latest updates through Ignite 2019!

sudhakars on 11-15-2019 03:20 PM
Since March of this year, the Azure Database for PostgreSQL team has been hard at work delivering new features and funct...
11.1K

Architecting petabyte-scale analytics by scaling out Postgres on Azure with the Citus extension

clairegiordano on 10-31-2019 01:12 PM
How does the Windows team at Microsoft assess the quality of new software builds to decide if the next software update i...
525

Visit the Azure Database for PostgreSQL team at Microsoft Ignite

craigkerstiens on 10-29-2019 08:32 AM
If you're attending Ignite make sure to check out some of the sessions from our open source database product and enginee...
3,368

Auto Failover with PostgreSQL 12

dimitrifontaine on 10-17-2019 10:11 AM
pg_auto_failover is PostgreSQL 12 compatible. This blog also shares a tip about changes to recovery configuration in Pos...
5,149

Auditing: Know what's going on in your Postgres database

Rachel Agyemang on 10-01-2019 08:29 AM
Do you know who is doing what on your Postgres database? pgAudit can help.
7,934

Database sharding explained in plain English

craigkerstiens on 09-23-2019 08:50 AM
Sharding is one of those database topics that most developers have a distant understanding of, but the details aren’t al...
1,840

Login and Permission Tips and Tricks in using pg_dump and pg_restore

Shau Phang on 09-20-2019 10:56 AM
Here are some tips and tricks that will help you in executing pg_dump and pg_restore in cloud environments.
2,402

Bring your data to Azure Database for PostgreSQL Hyperscale (Citus) using Azure Data Factory

Parikshit Savjani on 09-17-2019 08:00 AM
A core value proposition for running your PostgreSQL databases in a fully managed service such as Azure Database for Pos...
2,777

Python + Azure Database for PostgreSQL

ramkychan on 09-06-2019 02:19 PM
Python + Azure Database for PostgreSQL
13.7K

Not all Postgres connection pooling is equal

craigkerstiens on 08-27-2019 03:48 PM
There are different forms of connection pooling that have varying levels of impact when it comes to your database, learn...
844

Prevent the disaster of accidental deletion for your Postgres database on Azure

Rachel Agyemang on 08-27-2019 10:28 AM
Don't be the person who accidentally drops production Postgres databases in Azure
1,195

Performance Troubleshooting Basics on Azure Database for PostgreSQL

Bashar-MSFT on 08-22-2019 07:18 PM
Learn how to identify bottlenecks and resolve them
562

Azure Database for PostgreSQL feature releases and blog posts over the past year

Jim Toland on 08-19-2019 01:19 PM
We’ve been hard at work on Azure Database for PostgreSQL over the past several months, with several new feature/function...
1,290

Set up Pgpool-II Query Caching with Azure Database for PostgreSQL

BenjaminSatzger on 08-15-2019 09:51 AM
Steps to set up query caching and connection pooling using Pgpool-II and Memcached.
827

R + Azure Database for PostgreSQL

ramkychan on 08-14-2019 03:16 PM
R + Azure Database for PostgreSQL  
1,034

New Relic integration with Azure Database for PostgreSQL

Harini Gupta on 08-14-2019 09:00 AM
New Relic now provides an integration for Azure Database for PostgreSQL. If you are using New Relic as a monitoring solu...
Latest Comments
Badinvestor
in Application state – I want the easiest, most trouble-free deployment for the database on 12-30-2019
This is a very myopic view of self-managed databases. With docker and k8s you can easily build an image that has HA, replication, backups, dev self-service and security baked into it. Using docker, k8s, Patroni, and gitlab my small team of 7 DataOps members has quickly and easily built out a DaaS pl...
0 Likes
surentips
in Connection handling best practice with PostgreSQL on 11-09-2019
Good overview on connection handling Can I connect to Azure PostGre SQL using URI from external source? I am using MLFLow for ML model management and want to use Azure PostGre SQL for metrics and artefact storage. MLFLow supports URI storage with Azure Blob, but no mention of Azure PostGre
0 Likes
James van den Berg
in Architecting petabyte-scale analytics by scaling out Postgres on Azure with the Citus extension on 11-01-2019
Thanks for Sharing 
1 Likes
realprodnik
in Backup Azure Database for PostgreSQL to a Blob Storage on 10-22-2019
Thanks! Worked perfectly - apart from the 20min CloudShell timeout...
1 Likes
asdgwhfghvbn
in Bring your data to Azure Database for PostgreSQL Hyperscale (Citus) using Azure Data Factory on 10-18-2019
This works well for certain sources but fails when copying from an SQL database. See https://social.msdn.microsoft.com/Forums/en-US/bd53305d-301e-4847-abf7-8cab7ace5087/azure-data-factory-copy-pipeline-failing-if-more-than-6-columns
0 Likes