How Do I Know if My PostgreSQL Backup is Good?
Backups are a must in all Disaster Recovery Plan. It might not always be enough to guarantee an acceptable Recovery Point Objective, but is a good first approach. The problem is what happens if, in...
Using PostgreSQL Replication Slots
Curious how ClusterControl can help you design and implement environment agnostic deployment patterns? Join our final webinar of 2025! What are replication slots? Back in the days when "Replication Slots" were not yet introduced, managing...
Database Management & Monitoring for PostgreSQL 12
A few months ago we blogged about the release of PostgreSQL 12, with notable improvements to query performance (particularly over larger data sets and overall space utilization) among other important features. Now, with the ClusterControl...
Announcing ClusterControl 1.7.5: Advanced Cluster Maintenance & Support for PostgreSQL 12 and MongoDB 4.2
We’re excited to announce the 1.7.5 release of ClusterControl - the only database management system you’ll ever need to take control of your open source database infrastructure. This new version features support for the latest...
A SOx Compliance Checklist for PostgreSQL
The United States SOx (Sarbanes-Oxley) Act, 2002, addresses a broad spectrum of fundamental information security principles for commercial enterprises, ensuring their functions are rooted and consistently applied, based on concepts of CIA (Confidentiality, Integrity, and...
Cloud Vendor Deep-Dive: PostgreSQL on DigitalOcean
DigitalOcean is a cloud service provider, more of an IaaS (Infrastructure-as-a-Service) provider which is more suitable for small to medium scale businesses. You can get to know more about DigitalOcean here. What it does is...
PostgreSQL Database Monitoring: Tips for What to Monitor
Once you have your database infrastructure up-and-running, you’ll need to keep tabs on what’s happening. Monitoring is a must if you want to be sure everything is going fine or if you might need to...
Creating a Cold Standby for PostgreSQL Using Amazon AWS
The need to achieve database High Availability is a pretty common task, and often a must. If your company has a limited budget, then maintaining a replication slave (or more than one) that is running...
How to Avoid PostgreSQL Cloud Vendor Lock-in
Vendor lock-in is a well-known concept for database technologies. With cloud usage increasing, this lock-in has also expanded to include cloud providers. We can define vendor lock-in as a proprietary lock-in that makes a customer...
Top Ten Reasons to Migrate from Oracle to PostgreSQL
Oracle Relational Database Management System (RDBMS) has been widely used by large organizations and is considered by far to be the most advanced database technology available in the market. It’s typically the most often compared...
An Overview of VACUUM Processing in PostgreSQL
PostgreSQL does not use IN-PLACE update mechanism, so as per the way DELETE and UPDATE command is designed, Whenever DELETE operations are performed, it marks the existing tuple as DEAD instead of physically removing those...
PostgreSQL Deployment & Configuration with Puppet
Puppet is open source software for configuration management and deployment. Founded in 2005, it’s multi-platform and even has its own declarative language for configuration. The tasks related to administration and maintenance of PostgreSQL (or other...