PostgreSQL resources

Stay up to date with the latest PostgreSQL content, learn about upcoming events, join community discussions, and discover how Redgate tools can help solve your database challenges.

Simple Talk

In-depth articles and opinion from Redgate's technical journal

Show me

Events

We host and support a range of PostgreSQL focussed events

Show me

Forums

Ask, discuss, and solve questions on all things PostgreSQL

Visit the forum

Solutions

Redgate’s end-to-end Database DevOps solutions

Show me

PostgreSQL tools

Redgate pgCompare

The fastest way to compare & deploy PostgreSQL schemas

Learn more

Redgate pgNow

Get real-time insights into your database health, configuration, and performance

Learn more

New Book

Introduction to PostgreSQL for the data professional

Ryan Booz & Grant Fritchey

While the documentation around PostgreSQL is detailed and technically rich, finding a simple, clear path to learning what it is, what it does, and how to use it can be challenging. This book seeks to help with that challenge.

From getting your first instance, or cluster, up and running, to backups, to server configurations, we cover all the basics of how to get started within PostgreSQL. You'll learn about processing languages, monitoring, indexes and more. Every chapter provides fundamental knowledge and guidance to quickly get you up and running in PostgreSQL.

Get your free copy

Recent PostgreSQL articles on Simple Talk

Mercy Bassey
August 13, 2025
Secure PostgreSQL in Docker: SSL, Certificates & Config Best Practices
Learn how to run PostgreSQL in Docker with production-grade SSL encryption, certificate-based authentication, and custom configuration files - perfect for secure development environments.… Read more
Robert Sheldon
August 4, 2025
How to Use the psql Command-Line Tool with Azure Database for PostgreSQL Flexible Server
Learn how to install and use the psql command-line tool to connect to and manage Azure Database for PostgreSQL Flexible Server across macOS, Linux, and Windows.… Read more
Robert Sheldon
July 23, 2025
How to use pgAdmin with Azure Database for PostgreSQL flexible server
Learn how to connect and manage Azure PostgreSQL Flexible Server using pgAdmin, a powerful GUI tool for PostgreSQL.… Read more
Robert Sheldon
June 18, 2025
Getting started with Azure Database for PostgreSQL Flexible Server
Along with its many other cloud services, Microsoft now offers Azure Database for PostgreSQL Flexible Server, a database-as-a-service platform based on the PostgreSQL open-source database system. DBAs, developers, analysts, and other users who are familiar with relational database management systems—whether on-premises or in the cloud—should have little trouble getting started with ADP flexible server. That said, both the ADP service and the PostgreSQL RDBMS come with their own unique characteristics, and those who are new to ADP might benefit from a little guidance. This article and those to follow will introduce you to the ADP service and the various features...… Read more

Visit Simple Talk

Recent PostgreSQL product articles

Adam Britt
August 8, 2025
How to Identify and Fix Slow Queries in PostgreSQL
Struggling with slow queries in PostgreSQL? Learn how to spot and fix them fast, using a simple diagnostic process and the free tool pgNow. Read more
Phil Factor
July 18, 2025
Practical PostgreSQL Schema Comparison with Redgate pgCompare
Managing PostgreSQL schema changes across environments can be challenging, especially with complex dependencies. pgCompare highlights differences between two databases and generates reliable deployment scripts. This article shows how to get started with the tool and how it simplifies everyday tasks like reviewing feature branch changes, auditing schema drift, and creating build scripts. Read more
Grant Fritchey
January 16, 2025
Deploying PostgreSQL DB Changes Through AWS Developer Tools Using Flyway
Savan Dosanjh
October 28, 2024
Understanding PostgreSQL's Cache Hit Ratio
This article explores PostgreSQL's buffer cache hit ratio (BCHR), a metric tracked by Redgate Monitor to help you assess the health and performance of your databases. By correctly interpreting this ratio and using it with other relevant memory and IO metrics, you can identify potential bottlenecks in query execution before they impact users. Read more

Visit Product articles

PostgreSQL events at Redgate

Seattle
Community event

PASS Data Community Summit 2025

Join us in Seattle from 17–21 November for one of the world’s largest gatherings of data professionals. With two Pre-Conference days (Nov 17–18) and three full Conference days (Nov 19–21), this in-person event brings together thousands of data experts, developers, and community leaders to share knowledge, exchange ideas, and explore what’s next in database management and DevOps. Redgate at PASS Summit We’re proud to be part of the Summit again this year – with a full schedule of Redgate-led sessions, on-floor activities, and opportunities to connect throughout the week. Keynote by Kellyn Gorman Don’t miss Redgate’s Kellyn Gorman on the ...

Nov 17 - Nov 21, 2025

Workshop
Database DevOps

Virtual DevOps in a Day December

Join us for this hands-on virtual workshop. Database DevOps in a Day will get you started on your Database DevOps journey and illustrate how Redgate’s tools can help to bridge the gap between development and operations.

Dec 3, 2025
9:30am - 3:00pm GMT

Previous PostgreSQL events at Redgate

Community event

PostgreSQL Conference Europe 2025

We are proud to be sponsoring the 15th annual PostgreSQL conference Europe. Taking place in Riga, Latvia, with participation from PostgreSQL user groups across Europe, the conference aims to be a key meeting point for users from Europe and beyond. PGConf.EU provides a unique opportunity for European PostgreSQL users and developers to catch up, learn, build relationships, and establish a genuine professional network.

Webinar
PostgreSQL

Alles rund um PostgreSQL – Ask Me Anything

In diesem On-Demand-Webinar beantworten Dr. Benjamin Kettner und Nick Hape alle Fragen rund um PostgreSQL.

Webinar
PostgreSQL

PostgreSQL für Unternehmen - Einführung, Betrieb und Optimierung

In diesem Live-Webinar zeigen Redgate und CYBERTEC gemeinsam, wie Sie PostgreSQL erfolgreich im Unternehmen etablieren – von der Einführung bis zum produktiven Betrieb.

See more events

Redgate’s end-to-end Database DevOps solutions

Protect

For efficient software delivery

Transform software delivery with reliable test data management, automating repetition out of the process and improving release quality, while reducing risk.

Automate

Accelerate time to market

Deliver value to customers faster through automated database development with automation. Continuous integration and continuous delivery.

Monitor

Future-proof database monitoring

Designed for scalability and visibility, Redgate’s enterprise-grade portfolio solves complex database challenges, with solutions that support your growing database estate.

Get an overview of our solutions