Migrate Oracle to PostgreSQL: Roles and Privileges
Summary: In this article, you will learn the roles and privileges, and the differences between Oracle and PostgreSQL.
Migrate Oracle to PostgreSQL: PL/SQL vs PL/pgSQL
Summary: In this article, you will learn the features of procedural languages, and the differences between PL/SQL and PL/pgSQL.
Migrate Oracle to PostgreSQL: Understand the Concept of Schema
Summary: In this article, you will learn the concept of schema, and the differences between Oracle and PostgreSQL.
Migrate Oracle to PostgreSQL: NULL and empty strings
Summary: This article discusses the differences between how Oracle and PostgreSQL evaluate NULL characters and empty strings. Oracle reads empty strings as NULLs, while PostgreSQL treats them as empty. Concatenating NULL values with non-NULL characters results in that character in Oracle, but NULL in PostgreSQL.
What is Oracle GoldenGate for PostgreSQL supported?
Summary: This article introduces you what data types, objects, and operations supported in Oracle GoldenGate for PostgreSQL.
Configuring Oracle GoldenGate for PostgreSQL
Summary: This article lists details about configuring Oracle GoldenGate for PostgreSQL.
pgcopydb: pgcopydb command
Summary: This section of documentation is the reference manual of pgcopydb command.
pgcopydb: Resuming Operations (snaphots)
Summary: This section of documentation introduces you the resuming operations design in the pgcopydb program.
pgcopydb: Concurrency Design
Summary: This section of documentation introduces you the concurrency design in the pgcopydb program.
PGSync: Synchronize PostgreSQL data to Elasticsearch
Summary: PGSync is a middleware for syncing data from PostgreSQL to Elasticsearch/OpenSearch effortlessly.