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 initial years of my career, I predominantly worked with commercial relational database management systems (RDBMS) such as… Continue reading Is it possible for a DBA/DBE to earn 1 million USD annual compensation ?
Category: Uncategorized
Postgres for Oracle DBAs – Parameter Changes
Table of Contents What is included in this blog post ? This is Part 6 of the “Postgres for Oracle DBAs” series where we compare ‘parameter changes’. We covered 1) Default tablespaces 2) Executing sql scripts 3) Shutdown modes 4) Startup modes 5) alert log vs postgres log 6) Pg_dump Vs Datapump backups 7) Pg_restore… Continue reading Postgres for Oracle DBAs – Parameter Changes
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 we covered backup scenarios – Please read part 4 before reading this blog . We covered 1)… Continue reading Postgres for Oracle DBAs – impdp Vs Pg_restore
Postgres for Oracle DBAs – Datapump Vs Pg_dump
Table of Contents What is included in this blog post ? This is Part 4 of the “Postgres for Oracle DBAs” series where we compare logical backups – Data pump Vs pg_dump . We covered 1) Default tablespaces 2) Executing sql scripts 3) Shutdown modes 4) Startup modes 5) alert log vs postgres log in… Continue reading Postgres for Oracle DBAs – Datapump Vs Pg_dump