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
What is fillfactor in PostgreSQL – and when should you adjust it?
Learn how to optimize PostgreSQL performance with fillfactor - including how it affects HOT updates, indexing, and update-heavy workloads.… Read more
What are the top database platforms in 2026? A look at the latest data
Explore 2026 database market trends: AWS, Microsoft, Oracle, and Google Cloud Platform remain dominant as MongoDB, Snowflake, and Databricks steadily gain ground. Insights from Gartner and DB-Engines rankings.… Read more
How User-Defined Types work in PostgreSQL: a complete guide
Learn PostgreSQL User-Defined Types (UDTs) with clear examples of DOMAIN, COMPOSITE, ENUM, and RANGE types, plus practical SQL code for real-world use.… Read more
How to secure MySQL and PostgreSQL in the world of AI
Learn how AI is transforming database security and discover best practices to secure MySQL and PostgreSQL against AI-driven threats, faster attacks, and evolving vulnerabilities.… Read more
Recent PostgreSQL product articles
Test Data Manager: One-click deployment on AWS cloud
Deploy Redgate Test Data Manager into your own AWS account with a single CloudFormation click. Get a secure, production-ready environment for classifying, masking, and subsetting database copies in under 30 minutes, no infrastructure project required. Read more
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
PostgreSQL events at Redgate
Amsterdam: Adding PostgreSQL to your Data Skill Set
Discover the key differences, cloud considerations, and essential skills you need to confidently add PostgreSQL to your data toolkit in this expert-led Redgate Lunch & Learn. Lunch and drinks included!
AI meets Test Data: Compliance and coverage without the guesswork
Your masking scripts cover the columns you know about. Maybe you’ve vibe-coded a few extras to fill the gaps. But scripts only catch what you thought to account for, break quietly as schemas change, and “most of it” doesn’t hold up in an audit. Closing the compliance gap shouldn’t mean opening a quality one. But when test data is hard to generate realistically, most teams default back to production data, and the risk remains. In this session, we’ll show you how Redgate Test Data Manager uses AI securely to close both compliance and the data coverage gaps without your data leaving your environment. We’ll cover: Where DIY alternatives fall down and why auditors spot the gaps Where your data goes when AI is involved, and why our compliance-first approach means it stays with ...
Virtual DevOps In A Day
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.
Previous PostgreSQL events at Redgate
Compliance Without Compromise: Test Data Management That Finally Fits
You know sensitive production data shouldn't be in your test environments but the fixes feel impossible. Enterprise tools cost a fortune, DIY scripts break at scale, and so it stays on the backlog. This session shows you there's a third option.
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.
