Blog

Which PostgreSQL Upgrade Option Should You Choose?

When you’re upgrading PostgreSQL, you have two methods. Properly preparing for the upgrade and selecting the right choice depends on understanding the options.

10 Best Practices to Secure PostgreSQL AWS RDS/Aurora

When it comes to dealing with data in the cloud, security is a key aspect. Follow these 10 best practices in order to secure PostgreSQL AWS RDS/Aurora.

PostgreSQL Indexing Types: How & When to Use Them

PostgreSQL provides a variety of index types. Learn more about the different indexing types including how, when, and where to use them.

Enterprise-level High Availability Features in PostgreSQL

High availability is a must-have for effective enterprise database solutions. Enjoy 99.9999% always-on availability with the help of these PostgreSQL features.

Why Organizations are Migrating from Oracle to PostgreSQL

Oracle is a gold standard in enterprise database technology, but an increasing number of companies are making the switch to the open source PostgreSQL.

Let’s Compare: BARMAN vs. Manual Backup

BARMAN is one of the most popular tools for backup and recovery management in PostgreSQL. This blog compares BARMAN vs. manual backup options.

AWS IAM to Authenticate Against RDS Instances & Aurora Clusters

Authenticate your RDS instance or Aurora cluster without a password using AWS IAM. It works for PostgreSQL and MySQL databases on RDS.

Analyzing PostgreSQL RDS Workload with pgbadger

New blog post lays out the steps to help you analyze your PostgreSQL RDS workload with pgbadger.

Rotate Your TLS-SSL Certificate on RDS-Aurora Before February

AWS provides CA certificate for connecting to RDS instance using SSL/TLS. This certificate gets rotated frequently as part of ongoing maintenance and best practices.