Posts

Posted on

The Complete Oracle-to-PostgreSQL Data Type Mapping Guide

serene snowy mountain landscape with pines

TL;DR: Most Oracle-to-PostgreSQL data type mappings are straightforward.
The dangerous ones are not.
Oracle DATE includes a time component that PostgreSQL DATE silently discards.
Oracle NUMBER maps to NUMERIC by default, which is correct but slow for integer workloads.
Empty strings in Oracle are NULL; in PostgreSQL they are not.
This guide gives you the full mapping table and covers the five traps that cause silent data corruption during migration.

Continue reading “The Complete Oracle-to-PostgreSQL Data Type Mapping Guide”
Posted on

PostgreSQL Tools List: The Essential Stack for Production DBAs

river in green valley

TL;DR: PostgreSQL doesn’t ship with a built-in monitoring suite, backup manager, or HA framework — you assemble the stack yourself from specialised tools.
That’s not a weakness: it means you pick what fits your environment instead of paying for features you don’t use.
This list covers one best-in-class pick per category, with brief notes on when to use the alternatives.
Six categories are non-negotiable in production: HA/failover, backup and PITR, connection pooling, monitoring, query analysis, and log analysis.
Everything else is optional.

Continue reading “PostgreSQL Tools List: The Essential Stack for Production DBAs”