Azure Database for PostgreSQL

72Blog Articles

Options

1,710

andresfreund on 10-25-2020 09:37 AM

Improving connection scalability in Postgres 14. From the neat to the gritty: snapshot scalability edition.

2,093

dimitrifontaine on 10-08-2020 09:28 PM

All about what’s new in pg_auto_failover 1.4, an open source extension to Postgres for high availability & automated fai...

7,023

andresfreund on 10-08-2020 09:30 AM

Why it’s important to improve Postgres connection scalability, plus an analysis on the limits of connection scalability ...

5,946

Sunil_Agarwal on 10-03-2020 12:09 PM

A technical overview of the new Flexible Server option (now in Preview) in Azure Database for PostgreSQL.

5,002

Sunil Kamath on 09-22-2020 08:00 AM

Introducing the preview of a new deployment option, Flexible Server—bringing you more controls, confidence, and cost opt...

5,583

nilsdijk on 09-19-2020 09:43 AM

How we sped up percentile calculations for a customer by 45x using Postgres, Citus, and t-digest, without access to our ...

1,466

marcoslot on 09-16-2020 02:01 PM

Based on a Warsaw PostgreSQL Users Group talk, all about how Citus gives you Postgres at any scale. Includes a demo by o...

3,816

nazliugurkoyluoglu on 09-03-2020 11:49 PM

Story of how to use newly-released SQLancer to hunt for logic errors in databases using Ternary Logic Partitioning.

1,538

FranciscoPardillo on 08-25-2020 11:25 AM

Here you have an alternative way to alter a table column type based on an online migration using extra columns

1,791

FranciscoPardillo on 08-25-2020 11:24 AM

Examples of how to load data with Postgres COPY

2,826

mksunitha on 08-03-2020 10:50 PM

You can find Bitnami Certified Apps (“templates”) for Postgres on the Azure Marketplace. These templates are one-click s...

4,131

j-davis on 07-28-2020 08:51 AM

SCRAM with channel binding is a much more secure type of password authentication vs. traditional techniques such as md5 ...

2,583

korhan-ileri on 07-23-2020 07:25 PM

Tracking bloat in your Azure Database for PostgreSQL database is easy with custom metrics, Datadog, & this how-to post. ...

2,456

Sudheesh_N on 07-22-2020 04:46 PM

Don't keep credentials in your code - use a managed identity instead

2,286

zukoweh on 07-10-2020 10:12 AM

Security & compliance certificates on Azure Database for PostgreSQL—from HIPAA to PCI to SOC, and everything in between

1,934

Roland Lee on 07-02-2020 09:07 AM

Reduce backend connections to support high scale user counts

5,377

colton17 on 06-26-2020 09:45 AM

This is how we converted 2 billion Postgres rows from INT to BIGINT that were part of a primary key with 20 minutes of d...

1,729

manishku on 06-08-2020 02:07 PM

We are announcing the preview of encryption using customer managed key (Bring Your Own Key) support for the Azure databa...

1,563

Sudheesh_N on 06-03-2020 10:50 AM

You may want your read replica to be in a different subscription and resource group from the master server.

4,388

Rachel Agyemang on 05-19-2020 09:16 AM

How do you stream data changes from Postgres to caches, search indexes and more? With log-based change data capture.

4,450

tjukanov on 05-11-2020 08:26 AM

When you are working with spatial data using the PostGIS extension to Postgres, most of the Standard Query Language (SQL...

2,105

swjain on 04-29-2020 08:35 AM

Organize and collaborate on your Postgres database scripts with Projects in Azure Data Studio

2,183

ramkychan on 04-03-2020 02:10 PM

Using Terraform to create Private Endpoint for Azure Database for PostgreSQL - Single Server

5,399

tjukanov on 03-27-2020 01:09 PM

If you’re new to PostGIS and want to try it out, one of the first things you’ll want to do is to import some data into y...

1,447

Sudheesh_N on 03-24-2020 09:17 AM

Customize a dashboard for Postgres logs and metrics monitoring

2,274

LukasFittl on 03-23-2020 10:32 AM

Once you start having a large amount of databases, or more than one engineer on the team, management of your database us...

1,256

sudhakars on 03-16-2020 03:16 PM

An increasing number of companies are opting to run their open source workloads on Azure, and thus ensuring the security...

4,681

Rachel Agyemang on 03-09-2020 09:16 AM

Should you stick with the default Postgres log settings?

4,538

sudhakars on 03-03-2020 12:52 PM

Since Microsoft embarked on our journey with PostgreSQL, we’ve launched enterprise-grade features such as Intelligent Pe...

5,017

Rachel Agyemang on 02-24-2020 10:05 AM

Are you monitoring your Postgres server well? Start with this list of metrics and don’t forget alerts.

Latest Comments

in Architecting petabyte-scale analytics by scaling out Postgres on Azure with the Citus extension on 10-18-2020

A very informative article. Could you share some insights in to why Azure Sql was not considered for this ? Thanks, Harjit Singh

0 Likes

in Steps to install and setup PgBouncer connection pooling proxy with Azure DB for PostgreSQL on 09-30-2020

@Jack_Chen, correct. At this point what I am thinking to alleviate this concern is to load balance multiple instances of pgBouncer hosts.

0 Likes

in Steps to install and setup PgBouncer connection pooling proxy with Azure DB for PostgreSQL on 09-14-2020

I found that the above install instructions would not work without adding the following line to pgbouncer.ini under the section "[pgbouncer]": # had to add this to make the pgbouncer service run without any errors pidfile = /var/run/postgresql/pgbouncer.pid

0 Likes

in Steps to install and setup PgBouncer connection pooling proxy with Azure DB for PostgreSQL on 07-30-2020

Depends on the scenario. Yes, it is in the case with a single VM, but on the other hand, it's not a SPOF if you deploy it to AKS as one of the options suggested by @Parikshit Savjani

0 Likes

in Introducing Private Link for Azure Database for PostgreSQL Single server on 07-10-2020

Good article about Private Link for Azure DB for PostGreSQL.One thing that should be mentioned is that this feature is only available when an Azure Database for PostgreSQL with at least the General SKU is required. Basic SKU doesn't support it. Thanks,Giovanni

0 Likes