Postgres and Open Source Experts

An interesting micro optimization for pg_dump is coming in PostgreSQL 18.

We have seen a shift from the pandemic era work from home mandates to a new back to normal mandate of return to the office. This has caused a lot of frustration from workers. Much of the frustration is valid. Workers feel as if they can do their job more effectively if they work from home and that it provides better flexibility for managing non-work related responsibilities. There have been …

Background

On a recent call, a potential client shared their frustrations with the high costs and limitations of their managed services cloud platform. While reaching out to potential support providers, they often encountered companies that only supported PostgreSQL's community edition or pushed their closed-source editions. This experience highlighted the need for a consulting partner who takes a vendor-neutral approach.

Command Prompt prides itself on integrity, discipline, and excellence. We’re straight …

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 …