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 Blog
Options
774

Steps to install and setup PgBouncer connection pooling on Azure Kubernetes Services (AKS)

lesantana on Nov 25 2022 11:54 AM
The blog post is intended to focus on steps for install and setup the PgBouncer as a sidecar pattern enabling connection...
4,520

Reducing replication lag with IO concurrency in Postgres 15

thomasmunro on Nov 10 2022 10:16 AM
How Postgres 15 improves crash recovery & physical replication by increasing I/O concurrency & reducing replication lag.
1,791

Azure open-source databases enable businesses to do more with less

kelloconn on Nov 09 2022 08:33 AM
Over the last couple of years, new patterns have emerged as drivers for businesses considering moving their infrastructu...
1,521

How to leverage built-in connection pooler (PgBouncer) in Azure PostgreSQL Flexible Server

varun-dhawan on Nov 01 2022 02:30 PM
How to leverage built-in connection pooler (PgBouncer) in Azure PostgreSQL Flexible Server to scale connection performan...
1,684

Secure PostgreSQL Flex Server data with encryption and customer managed keys (Preview)

Gennadyk on Oct 18 2022 04:55 PM
Learn more about securing your PostgreSQL Flexible Server data at rest using encryption at rest with customer managed ke...
1,992

Azure PostgreSQL Flexible Server has three exciting new backup and restore enhancements.

varun-dhawan on Oct 17 2022 09:43 AM
Introducing Fast Restore, Geo Restore and Custom Restore Points to Azure Database for PostgreSQL Flexible Server.
2,691

Ignite 2022 - Continued innovation with Azure Database for PostgreSQL flexible server

sridrang on Oct 12 2022 11:26 AM
We are committed to making Azure Database for PostgreSQL flexible server the most advanced Postgres database service for...
1,997

How to Add More Environments to the Postgres CI

melihmutlu on Sep 30 2022 09:38 AM
Instructions for how to enable and use the PostgreSQL CI—plus how to add new environments to it as well.
1,465

How to enable query logging in Azure database for PostgreSQL?

varun-dhawan on Sep 28 2022 07:44 PM
In this post, we will share step-by-step instructions for enabling and viewing query logging for Azure Database for Post...
2,248

How do I check logs for Azure Database for PostgreSQL?

varun-dhawan on Sep 07 2022 12:56 PM
Step-by-step guide on how configure and view logs in in Azure Database for PostgreSQL Flexible Server.
2,291

Lower your total cost of ownership with Azure Database for PostgreSQL

kelloconn on Aug 11 2022 03:26 PM
The Enterprise Strategy Group (ESG) conducted an economic value study on the top-level benefits and cost savings that bu...
5,506

Debugging Postgres autovacuum problems: 13 tips

samay_sharma on Jul 28 2022 09:03 AM
The definitive post for optimizing Postgres autovacuum, along with 13 tips on how to fix the most common vacuum issues.
3,301

Single to Flexible server PostgreSQL migration tool is now in Preview!

sridrang on Jul 27 2022 10:17 AM
Learn about migrating your Single Server to Flexible Server PostgreSQL seamlessly using a new in-line migration tool.
1,738

Introducing support for Pgrouting and PLV8 extensions in PostgreSQL Flexible Server

Gennadyk on Jul 07 2022 07:53 PM
Introducing support for pgrouting and plv8 extensions in Azure PostgreSQL Flexible Server.
2,378

PostgreSQL v14 is now available in Flexible Server PostgreSQL!

sridrang on Jun 30 2022 12:44 PM
You can now deploy PostgreSQL version 14 on Azure Database for PostgreSQL Flexible Server!
2,494

Achieve high uptime with Flexible Server PostgreSQL HA!

sridrang on Jun 20 2022 04:57 PM
Learn about high availability deployment models, new HA capabilities, and how to achieve high uptime with Azure Database...
4,110

Building IoT apps using Postgres, Citus, and Azure

Manjunath_Suryanarayana on Jun 14 2022 10:29 AM
Learn about a reference architecture for building scalable IoT time-series apps with Postgres, Citus, and Azure.
4,278

Secure your Java application connections to Flexible Server via JDBC and SSL

Gennadyk on May 27 2022 08:24 AM
Postgres Flexible Server on Azure requires secure connection by default. In this post, we will explain to you how to set...
17.7K

Speeding up sort performance in Postgres 15

David_Rowley on May 19 2022 09:28 AM
All about the sort performance gains in the upcoming PostgreSQL 15 open source release.
5,872

Moving Postgres data 26X faster with Azure Data Factory

halilozanakgul on May 17 2022 09:23 AM
All about new ADF features for moving data to or from Postgres on Azure, that speed up both reads and writes.
5,768

How to benchmark performance of Citus and Postgres with HammerDB on Azure

JelteF on Mar 12 2022 09:50 AM
Deep dive into database performance benchmarks, including sample benchmark results for Citus and Postgres on Azure.
3,281

Introducing ability to allow-list extensions in PostgreSQL Flexible Server

Gennadyk on Feb 27 2022 04:53 PM
Introducing allow-listing extensions using azure.extensions server parameter in Azure PostgreSQL Flexible Server. As add...
2,194

Call for speakers for Citus Con: An Event for Postgres

clairegiordano on Jan 31 2022 09:34 AM
The CFP is open until Feb 6, 2022 for Citus Con: An Event for Postgres—a free and virtual developer event.
2,829

Why give a conference talk (or, why give a Postgres talk)

clairegiordano on Jan 11 2022 10:31 AM
How giving a talk at a Postgres event can benefit the Postgres community—and also you, your team, & your project.
2,990

Deploy a connectivity dashboard for PostgreSQL Flexible Server

seernu on Jan 06 2022 07:05 PM
How to deploy and use a dashboard to monitor connectivity patterns in Azure Database for PostgreSQL Flexible Server.
3,238

Create a Connectivity Dashboard for Postgres Single Server in Azure

seernu on Dec 18 2021 06:04 PM
Deploy using ARM template or manually create a dashboard to monitor connectivity patterns in PostgreSQL - Single Server ...
80.9K

UK COVID-19 dashboard built using Postgres and Citus for millions of users

clairegiordano on Dec 11 2021 09:48 AM
Why and how the UK Coronavirus Dashboard team built their analytics service on top of PostgreSQL & Citus on Azure.
13.9K

Azure Database for PostgreSQL – Flexible Server is now GA!

Sunil Kamath on Nov 30 2021 08:00 AM
We're extremely excited to announce General Availability (GA) of Azure Database for PostgreSQL – Flexible Server in more...
8,767

Private Networking Patterns in Azure Database for Postgres Flexible Server

Gennadyk on Nov 29 2021 01:59 PM
Understanding networking architecture is crucial when deploying Flexible Server in your enterprise Azure footprint.
5,426

Introducing Private Link in Hyperscale (Citus) for Postgres on Azure

rongxunwang on Nov 06 2021 10:14 AM
How to use private link (preview) in Hyperscale (Citus) in Azure Database for PostgreSQL to connect securely & privately...

Latest Comments

varun-dhawan
in Steps to install and setup PgBouncer connection pooling proxy with Azure DB for PostgreSQL on Nov 15 2022 02:37 PM
Azure Postgres Flexible Server now offers "built-in" PgBouncer for all regions. For more details on how to use, please refer customer docs - https://learn.microsoft.com/en-us/azure/postgresql/flexible-server/concepts-pgbouncer
0 Likes
richwhitfield
in Connect from Function app with managed identity to Azure Database for PostgreSQL on Nov 14 2022 10:04 PM
I also had the same issue on step 3 'Enterprise Applications' was pre-selected and had filtered out my project
0 Likes
varun-dhawan
in Steps to install and setup PgBouncer connection pooling proxy with Azure DB for PostgreSQL on Nov 07 2022 08:19 AM
@Naresh560 Thanks for reading and seeking clarification. - Can you give more info details about this error, especially if there any other errors in logs before this TLS error.Also, please note- In Azure Database for Postgres Flexible Server, PgBouncer is "built-in" and does NOT requires any separate...
0 Likes
varun-dhawan
in Debugging Postgres autovacuum problems: 13 tips on Nov 02 2022 11:32 AM
This is a really informative post (and the video) and recommend for anyone trying get a good grasp postgres vacuuming - good job @samay_sharma !
0 Likes
Naresh560
in Steps to install and setup PgBouncer connection pooling proxy with Azure DB for PostgreSQL on Oct 19 2022 02:30 AM
I am getting this error while connecting postgress using pgbouncerpsql: error: could not connect to server: ERROR: client_login_timeout (server down)On logs i see like this 2022-10-19 09:25:23.985 UTC [7004] WARNING TLS connect error: failed to load CA: Permission denied
0 Likes