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.
A PostgreSQL 13 Feature Deep-dive
PostgreSQL is an open-source relational database solution known for delivering powerful functionality. Here’s a look at the newest additions in PostgreSQL 13.
The Risk of Running Legacy Database Technology
End of life comes for most technology, databases being no exception. Learn more about the risks of running legacy database technology.
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
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.
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.