Security and compliance
Ensure data security and compliance with 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
The key syntax differences between MySQL and PostgreSQL – everything you should know
Migrating from MySQL to PostgreSQL? Learn the key SQL syntax differences - identifier quoting, auto-increment, LIMIT vs FETCH FIRST, and more.… Read more
How to fix “too many connections” in PostgreSQL (step-by-step guide)
Getting PostgreSQL's "too many connections" error? Learn what causes it, how to reproduce it safely, and 5 proven fixes — including connection pooling and monitoring with pg_stat_activity.… Read more
How to create roles, databases and tables in PostgreSQL (getting started with PostgreSQL, part two)
Learn how to create roles, databases, schemas, and tables in PostgreSQL using psql. Step-by-step commands, real output examples, and best practices included.… Read more
Why PostgreSQL shouldn’t be your app’s answer to everything
A DBA explains why using PostgreSQL for queuing, caching, or document storage creates ownership gaps, security risks, and higher cloud costs.… Read more
Recent PostgreSQL product articles
Aurora PostgreSQL monitoring: cluster and instance visibility, in Redgate Monitor
Teams running Aurora PostgreSQL today have limited options for keeping on top of cluster health. CloudWatch gives you raw metrics and alarms, but no unified view of performance and health of nodes within a cluster, and no built-in way to go from an infrastructure metric to the query behind it. 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.
Previous PostgreSQL events at Redgate
PostgreSQL Fireside Chat
Join Pat Wright, Advocate at Redgate, and a PostgreSQL expert from CYBERTEC for an hour of unscripted conversation about where Postgres is headed and what it means for the people running it.
PostgreSQL Conference Europe 2026
We are proud to be sponsoring the 16th 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. Stop by the Redgate booth to chat with our friendly team and discover how Redgate puts you in control of your databases, supporting automation, enabling secure scaling, and unlock growth through AI. Register here.
Das PostgreSQL-Migrationspuzzle
In diesem Webinar sprechen Redgate und CYBERTEC über den langen, steinigen Weg der Datenbankmigration von proprietären DBMS hin zu PostgreSQL.
