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
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
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
PostgreSQL is a robust and trusted database platform, but it’s not invincible. The PostgreSQL Global Development Group “takes security seriously,” enabling users to trust it with mission-critical data (PostgreSQL: Security Information). However, simply running PostgreSQL with default settings or careless practices can be like leaving your solid steel front door unlocked or even opened. You have the protection mechanisms, you just aren’t using them. A very common concern is that security vulnerabilities can creep in through mistakes in how we write queries, configure the server, or especially how we manage user privileges. In fact, the PostgreSQL documentation itself emphasizes that...… Read more
Date and time data types are important because they help track and manage time-based information in databases. This includes things like recording when orders are placed, scheduling events, or calculating the time between two activities. In this article, we will look at differences between how PostgreSQL and MySQL stores and utilizes date and time datatypes. MySQL and PostgreSQL offer several data types that can be used for handling dates and times. These data types provide the tools to store and manage information like dates of a particular event, timestamps, and even time durations. While they both share some similarities on...… Read more
The Postgres database management system was originally designed as object-relational. We remind why PostgreSQL is an object-relational rather than just relational database management system, and briefly discuss what kind of object-oriented features it offers. We demonstrate how these features can be used to manage hierarchies, and how applications can benefit using them. The discussion is illustrated with examples of SQL code based on the postgres_air database [6, https://github.com/hettie-d/postgres_air]. There are many ways to implement a hierarchy in a relational database. Techniques with names like adjacency lists and nested sets, not to mention some other RDBMS have built methods of managing...… Read more
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
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
Current Activity for PostgreSQL in Redgate Monitor provides a real-time view of queries currently running on your PostgreSQL instances. It will allow you to identify quickly any queries that are currently causing blocking and resource contention issues on an instance. Read more
Nutzen Sie die Gelegenheit, Ihre Fragen zu PostgreSQL zu stellen – Dr. Benjamin Kettner, Analysis & Software Architect (CTO) bei ML!PA Consulting GmbH, wird sie gemeinsam mit dem Redgate-Team beantworten.
Redgate auf dem PGDay Austria 2025 Der PGDay Austria bringt PostgreSQL-Profis, Entwickler:innen und Datenbank-Enthusiast:innen aus ganz Europa zusammen – mitten im Herzen Wiens. Redgate ist als Sponsor vor Ort und freut sich darauf, mit Ihnen ins Gespräch zu kommen. An unserem Stand erhalten Sie Einblicke in unsere neuesten Tools für die PostgreSQL-Entwicklung und das Monitoring. Tauschen Sie sich mit unserem Team über Ihre aktuellen Projekte und Herausforderungen aus – und nutzen Sie die Gelegenheit, an unserem Gewinnspiel teilzunehmen. Natürlich haben wir auch wieder exklusiven Redgate-Swag für Sie dabei. Ob Sie bereits mit Redgate arbeiten oder unsere Lösungen erst kennenlernen möchten ...
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.
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.
