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
It’s 2026. Why are databases still failing GDPR compliance audits?
GDPR erasure failures are often database engineering problems, not legal ones. Learn how relational schema design, backup retention, and audit logging create compliance gaps — and how SQL Server, PostgreSQL, Oracle, and MySQL compare. … Read more
Why migrating from Oracle is harder than anyone admits – and what you should do instead
Oracle-to-Postgres migrations routinely go over budget — not because of schemas, but because of DBMS_* packages. Learn what breaks, why automated tools miss it, and how to build an honest migration plan.… Read more
How data scientists work with PostgreSQL from Python (and how to write queries that don’t break at scale)
In this article, learn how PostgreSQL powers data science workflows, including query execution, performance optimization, indexing, data retrieval, and more.… Read more
How to automate vector embeddings with pgai Vectorizer in PostgreSQL
Automate PostgreSQL vector embeddings with pgai Vectorizer. Learn how to sync pgvector embeddings automatically using Timescale’s AI-powered workflow.… 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
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.
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
PG Data Conference 2026
Redgate is proud to be a platinum sponsor at PG Data Conference 2026 PG DATA 2026 brings two days of PostgreSQL programming to the Midwest DBA and software developer communities. They aim to offer an accessible and affordable in-person event where attendees can connect with peers, get hands-on training from industry-leading experts, and learn about everything Postgres, from deep dives into database internals to case studies, analyses of the latest features, and more. Stop by the Redgate booth to talk all things Postgres! More information and tickets here.
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.
