Security and compliance
Ensure data security and compliance with data masking, monitoring, and change traceability
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.
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
How to Build an AI-Powered Semantic Search in PostgreSQL with pgvector
Learn how to build a sleek, AI-powered semantic search engine that lives inside your existing database. We’ll walk through how to store vector embeddings, run similarity-based queries, and turn ordinary text searches into meaning-aware retrieval with nothing more than standard SQL and a vector extension.… Read more
MySQL vs PostgreSQL: JSON Data Types
MySQL and PostgreSQL both support JSON, but they handle it in very different ways. This article compares their JSON data types, performance, and use cases to help you choose the right database for your application.… Read more
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
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
Recent PostgreSQL product articles
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
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
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
PostgreSQL events at Redgate
CERN PGDay 2026
We are excited to join the PostgreSQL community at CERN for the second edition of PGDay. This event is a key gathering for data professionals and enthusiasts in Western Switzerland and the Geneva region. Following a successful debut, this event returns to the inspiring setting of CERN to bring together the data community from across the public, private, and scientific sectors.
PostgreSQL Conference Germany 2026
Wir freuen uns, bei der 10. Jubiläumsausgabe der PostgreSQL Conference Germany in Essen dabei zu sein. Die PGConf.DE ist ein zentraler Treffpunkt für Anwender und Entwickler aus ganz Europa, um sich zu vernetzen und Wissen rund um PostgreSQL zu vertiefen. Die Konferenz bietet eine einzigartige Gelegenheit, wertvolle Kontakte zu knüpfen und die Zusammenarbeit innerhalb der professionellen PostgreSQL-Community zu stärken. Es ist der ideale Ort, um neue Beziehungen aufzubauen und sich mit Experten über die neuesten Entwicklungen auszutauschen.
Previous PostgreSQL events at Redgate
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 ...
Alles rund um PostgreSQL – Ask Me Anything
In diesem On-Demand-Webinar beantworten Dr. Benjamin Kettner und Nick Hape alle Fragen rund um 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.
