Is it possible for a DBA/DBE to earn 1 million USD annual compensation ?
Table of Contents My journey from Traditional RDBMS DBA to Opensource DBE/DBA My journey in the field of database administration (DBA) commenced in 2006 when I took on the role of an IBM DB2 DBA. During the...
Read More ➜
Postgres INT out of range – What to do ?
Table of Contents Introduction – What is covered here ? “ERROR: integer out of range” : This error can cause a lot of trouble in production environments . We are going to cover this scenario in detail here...
Read More ➜
HBA Checker – KloudDB Shield 1.4
Table of Contents What is klouddb_Shield ? Klouddb_Shield is an open source security tool that checks for CIS compliance . Currently we check for 8 RDS controls , 40 controls(Postgres) , 46 MySQL controls – a total of...
Read More ➜
KloudDB Shield 1.3 – HTML Feature
Table of Contents What is klouddb_Shield ? Klouddb_Shield is an open source security tool that checks for CIS compliance . Currently we check for 8 RDS controls , 32 controls(Postgres) , 46 MySQL controls – a total...
Read More ➜
Postgres User Poll Results – Part 1
Table of Contents What is included in this blog post ? In this blog post we are presenting poll results for several polls published on Linkedin by KloudDB . Poll topics included are 1) Type of replication...
Read More ➜
KloudDB Shield 1.2 – RDS CIS Benchmarks
Table of Contents What is klouddb_shield ? Klouddb_Shield is an open source security tool that checks for CIS compliance( https://www.cisecurity.org/cis-benchmarks/) . Currently we check for 8 RDS controls , 32 controls(Postgres) , 46 MySQL controls – a total...
Read More ➜
Postgres for Oracle DBAs – impdp Vs Pg_restore
Table of Contents What is included in this blog post ? This is Part 5 of the “Postgres for Oracle DBAs” series where we compare logical backup restores – Data pump restore Vs pg_dump restore(pg_restore). In Part 4...
Read More ➜
CIS Benchmarks for Postgres – KloudDBShield 1.1
Table of Contents What is klouddb_shield ? Klouddb_Shield is an open source security tool that checks for CIS compliance( https://www.cisecurity.org/cis-benchmarks/) . Currently we check for about 32 controls(Postgres) and we plan to add more checks soon We tested...
Read More ➜
Pgfincore and Pg_buffercache to troubleshoot performance issues
Table of Contents What is included in this blog post ? In this blog post we discuss about the importance of pg_buffercache and pgfincore extensions . Postgres uses shared_buffers and OS cache to cache data,indexes,.. (In Aurora it...
Read More ➜
Postgres for Oracle DBAs – Script execution and default tablespaces
Table of Contents What is included in this blog post ? We are starting “Postgres for Oracle DBAs” series with this post . In this post we compare two aspects – 1) Executing sql scripts 2) Default...
Read More ➜