Posts

An in-depth analysis of PostgreSQL streaming replication principles and process architecture, covering synchronous and asynchronous modes and failover switchover mechanisms.

A detailed explanation of PostgreSQL logical replication mechanisms, covering logical decoding, replication slots, output plugins, and publish/subscribe architecture.

Complete hands-on steps for setting up Oracle GoldenGate PostgreSQL-to-Oracle data synchronization, covering environment configuration, OGG installation, and sync link creation

Hands-on steps for setting up Oracle GoldenGate Oracle-to-PostgreSQL sync link, covering environment preparation, OGG installation, parameter configuration, and sync verification.

Sharing my experience of getting into Wuhan University's part-time graduate program, covering differences between full-time and part-time, choosing a major and school, the management exam content, and early interview strategies

An introduction to the pg_rewind tool, its use cases and hands-on steps for resynchronizing after primary-standby timeline divergence, including wal_log_hints parameter configuration.

Notes on Sapiens: from the Cognitive Revolution to money and empire, how Homo sapiens built civilization through the power of fiction, exploring humanity's grand journey from animals to gods

Notes on Rich Dad Poor Dad: the core idea that 'the poor work for money, while the rich make money work for them,' exploring financial literacy and the gap between passive and active learning

Notes on Elon Musk: from Zip2 to SpaceX and Tesla, the legendary entrepreneurial journey of disrupting multiple industries with the ultimate mission 'for humanity'

Notes on Educated and Atomic Habits: a legendary true story of how education transforms destiny, and the scientific methodology of building good habits