Postgres and Open Source Experts

Anytime. Anywhere. Since 1997.

Blog

PostgreSQL 18: Revolutionary Performance Boost Now Available

The PostgreSQL Global Development Group has released PostgreSQL 18, delivering the most significant performance improvements in recent years. This latest version transforms database I/O operations and streamlines the upgrade experience for organizations worldwide.

Why Growing Teams Are Moving from Aurora to RDS or EC2: Cost and Control Considerations on AWS

Amazon Aurora PostgreSQL can be a powerful starting point for teams adopting PostgreSQL in AWS. But as usage grows, so do the needs for cost transparency, fine-grained tuning, and architectural flexibility. Here's why more teams are choosing Amazon RDS for PostgreSQL or EC2 as they scale.

PgManage 1.3.1: Enterprise Edition Released

PgManage 1.3.1 is now available with fixes across PostgreSQL, Oracle, MariaDB, and SQLite3, plus updated dependencies and UI refinements. Learn what’s new and explore PgManage Enterprise Edition with remote access, multi-user support, and OAuth2 integration.

Lessons from the CISA and USCG Joint Advisory: What “No Breach” Still Reveals

The July 31st advisory from CISA and the U.S. Coast Guard (AA25-212A) is less about what happened and more about what could have. A proactive threat hunt at a U.S. critical infrastructure organization revealed no active compromise, but it uncovered systemic weaknesses like insecure credentials, unrestricted remote access, and insufficient monitoring. This is a textbook case of “security theater”: policies and tools on paper, without enforcement in practice. The takeaway is clear: no evidence of compromise is not the same as no risk.

Upgrading PostgreSQL and Citus for Enhanced Database Functionality

Discover how a client successfully upgraded PostgreSQL 11 to 15.5 and Citus 8.3 to 12.1 while simplifying extensions, improving scalability, and enhancing performance. This real-world case study highlights the planning, testing, and expertise required to achieve seamless upgrades in distributed environments.

Critical Security Alert: Immediate Action Required for Self-Hosted SharePoint Servers (CVE-2025-53770)

A critical, newly disclosed, and actively exploited vulnerability, CVE-2025-53770, affects all self-hosted / on-premises Microsoft SharePoint Server versions. This critical issue does not impact SharePoint Online (Microsoft 365).

The exploit enables attackers to:

  • Bypass authentication
  • Install persistent backdoors
  • Launch ransomware
  • Steal sensitive data

Immediate Steps to Take:

  • Patch all on-premises SharePoint servers immediately following Microsoft guidance
  • Disconnect unpatched servers from the Internet immediately
  • For versions older than SharePoint 2016: …

PgManage 1.3 Release: Powerful New Features and Enhanced Usability

PgManage 1.3 is here with major updates including a redesigned dashboard UI, JSON export, code folding, PostgreSQL 17 support, and more. This release focuses on usability, performance, and cross-database compatibility, enhancing your workflow whether you're using PostgreSQL, MariaDB, MySQL, or others.

The Freedom to Choose: Why Vendor-Neutral Consulting Matters

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 …

Navigating Compliance in Regulated Industries

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

Support California Wildfire Relief Efforts

2025_Palisades_Fire_Seen_From_Palisades_Drive_(cropped)

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. …