Postgres and Open Source Experts

Planning and road-mapping updates not only address immediate issues but also contribute to long-term stability and security, helping your organization avoid major headaches down the road.

The PostgreSQL Global Development Group recently released important updates for several supported PostgreSQL versions, including 16.4, 15.8, 14.13, 13.16, 12.20, as well as the 17 Beta 3. One security vulnerability and over 55 bugs were addressed, many of which affect PostgreSQL 16 and other supported versions.

As the summer winds down, many of us have experienced a professional lull with school breaks and summer vacations.

This transition offers a golden opportunity to prepare for a successful fall. Our team of System Admins and DBAs has compiled top strategies to make the most of this period:

1. Plan and roadmap future updates.
2. Determine which OS updates you’ve been putting off and do them
   1. Execute pending OS and database …

PgManage 1.1, a usable Open Source Postgres manager, has been released

PgManage 1.0 released, grab it today!

Sometimes, after using a tool for many years, you will discover a feature that totally changes how you do things. When it is a fundamental tool like “less”, it changes how you interact with many command line programs in Linux*.

Did you know that less can do far more than just press space to advance to the next page? I sure didn’t. Then one day I went down the rabbit …

pgBackRest is a complete backup and continuous archiving solution for PostgreSQL offering support for point-in-time recovery (PITR), fast multi-threaded backup and restore, compression and encryption of backups, and more. In this article, we will explore pgBackRest’s features and present how to set up a basic pgBackRest configuration.

PgManage 1.0rc1 released - an inch closer to being a mile ahead

This is a courtesy notification to our clients and community regarding an alleged security issue for PostgreSQL 12.2.

The following issue was reported as CVE-2020-21469:

An issue discovered in PostgreSQL 12.2 allows attackers to cause a denial of service via repeatedly sending SIGHUP signals.

This is not a security vulnerability, and was filed without prior knowledge of or consultation with the PostgreSQL Security Team as reported in this …

PgManage 1.0b2 released.