Postgres and Open Source Experts

Command Prompt: Your U.S.-Based Partner for Navigating Compliance in Regulated Industries

As we witness the destruction caused by the California wildfires, we’re reminded of the importance of coming together to support those in need. If you are looking for ways to help, here are a few trusted organizations assisting:

1. California Fire Foundation Wildfire & Disaster Relief Fund - This fund supports immediate relief efforts, as well as long-term recovery and rebuilding initiatives for wildfire-affected communities. Learn more and donate here. …

In Part 1 of this series, we discussed the importance of robust change control policies in managing system modifications and minimizing disruptions. But even the best-planned changes can sometimes go awry. That’s where rollback plans come in as a vital safety net. In Part 2, we’ll focus on the essential role of rollback plans, examining how they minimize downtime, maintain data integrity, and build confidence in your team’s ability …

Discover how robust change control policies can safeguard your technology projects from unexpected disruptions. Learn the key components of effective change management, including communication, approval processes, and detailed testing strategies.

PostgreSQL is an open-source, feature-rich, and highly extensible relational database system used globally across countless sectors. Over the years, it has grown significantly with each release, becoming one of the most reliable databases for developers and enterprises. Let’s explore the PostgreSQL roadmap, focusing on its major version changes, key features introduced in newer releases, use cases, and why upgrading is essential for better stability and performance.

PostgreSQL's Naming Convention Shift: …

The latest PostgreSQL updates were released on November 21, 2024, which address critical issues affecting data integrity and system stability.

PostgreSQL Versions Update

The PostgreSQL Global Development Group has released updates for all supported versions: 17.2, 16.6, 15.10, 14.15, and 13.18. Additionally, due to the nature of one of the issues in the previous update release, they have also released version 12.22 for PostgreSQL 12, even though it has reached …

The latest version of PgManage has been released! PgManage 1.2 Release introduces new features and improvements, and addresses several bugs reported since the last release. Please update to the latest version at your earliest convenience.

New features:

• Implemented support for adding/changing table indexes in Schema Editor
• Implemented Postgres role editor
• Added SQL error annotations in the query editor
• Significant code completion improvements: added context-aware schema, table, view, column and function …

The latest version of PgManage has been released! PgManage 1.1.1 Release introduces new features and fixes 1 security vulnerability and several bugs reported since the last release. Please update to the latest version at your earliest convenience.

• New features:
  • Added IPv6 support for database connections
  • Allow using UNIX domain socket paths in connection form -> server field (#438)
  • Allow empty server values in the connection form for Postgres …

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 …