Blog
Welcome to Datavail’s Blog, where you can read the latest insights, tips and opinions of our experts on all things data and technology.
10 Best Practices to Secure PostgreSQL AWS RDS/Aurora
Follow these 10 best practices in order to secure PostgreSQL AWS RDS/Aurora.
PostgreSQL Indexing Types: How, When & Where Should They Be Used?
New blog post lays out what are indexes supported by PostgreSQL following with when to use which type of index.
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.
Open Source PostgreSQL Offers Boon to Business
If your organization is looking for more flexibility and control while also to save money while managing its data, PostgreSQL may be the DBMS for you.