Postgres and Open Source Experts

Anytime. Anywhere. Since 1997.

Education

Professional Postgres and Open Source support

Command Prompt, Inc., is the oldest Postgres Company in North America and one of the oldest Open Source firms still operating today. We serve our clients with best in class expertise and professionalism. You can read more about support and services here:


You have landed at the largest single source of Postgres education blogs in the world. At Command Prompt, we believe deeply that the education of the community is critical to the continued success of Postgres and related technologies. We hope you find content you are looking for and don't hesitate to Contact us today for all your Postgres and Open Source consulting and support needs.

The Risks of Not Having a Multi-Region PostgreSQL Cluster

Introduction:

In today's fast-paced digital landscape, data is at the heart of every organization's success. The PostgreSQL database system is a robust and popular choice for managing critical data, but ensuring database availability, scalability, and resilience is crucial. One strategy that can significantly mitigate risks associated with database availability is adopting a multi-region architecture. SaaS applications in particular are often implemented as single-region applications, and can benefit greatly from a multi-region approach.  In this blog post, we'll delve deep into the risks of not having a multi-region strategy for your PostgreSQL database system and explore why it's a game-changer in today's data-centric world.

pglogical Rediscovered: A Fresh Approach to Logical Replication for Ultra-high Availability

by Hari Kiran

August 22, 2023

Data replication is an essential aspect of modern database management systems, ensuring data availability, fault tolerance, and scalability. In the PostgreSQL world, a groundbreaking extension called Spock has emerged, transforming the way multi-active replication is handled. Spock, based on the pglogical logical replication tool, brings in a host of new features, including conflict resolution and avoidance, asynchronous replication, and more. In this blog post, …

What is PostgreSQL?

PostgreSQL is the only Open Source database in the world that focuses on correctness first and extends that correctness to features such as NoSQL (JSON), ASYNC/SYNC Binary and Logical Replication. PostgreSQL also has features such as Horizontal partitioning, Stored Procedures and abilities to use replication to other legacy database systems such as MSSQL and Oracle.

PostgreSQL EOL (Extended Support)

Command Prompt with an appropriate support contract will provide 24x7x365 support for EOL versions of PostgreSQL up to 8 years from the initial release date. This extends the support lifecycle of a PostgreSQL release by 3 years.

EnterpriseDB (EDB) vs PostgreSQL

Command Prompt understands that sometimes a closed source version of software provides better features than the Open Source counterparts. However, it is Command Prompt’s considerable experience over 25 years of providing expert PostgreSQL professional services and support that there are a minute number of closed source opportunities for PostgreSQL. The ecosystem and community is vibrant and continuing to solve the problems that enterprises face in a collaborative and Open Source way.