Migration

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.

Continue reading

What is Oracle GoldenGate for PostgreSQL supported?

Summary: This article introduces you what data types, objects, and operations supported in Oracle GoldenGate for PostgreSQL.

Continue reading

Configuring Oracle GoldenGate for PostgreSQL

Summary: This article lists details about configuring Oracle GoldenGate for PostgreSQL.

Continue reading

pgcopydb: pgcopydb command

Summary: This section of documentation is the reference manual of pgcopydb command.

Continue reading

pgcopydb: Resuming Operations (snaphots)

Summary: This section of documentation introduces you the resuming operations design in the pgcopydb program.

Continue reading

pgcopydb: Concurrency Design

Summary: This section of documentation introduces you the concurrency design in the pgcopydb program.

Continue reading

PGSync: Synchronize PostgreSQL data to Elasticsearch

Summary: PGSync is a middleware for syncing data from PostgreSQL to Elasticsearch/OpenSearch effortlessly.

Continue reading

pgcopydb: Introduction

Summary: The pgcopydb program is a tool that automates copying a PostgreSQL database to another server.

Continue reading

pgcopydb: Features Highlights

Summary: This section of documentation introduces you the major features in the pgcopydb program.

Continue reading

pgcopydb: Copy a PostgreSQL database to a target server

Summary: The pgcopydb program is a tool that logically copying a PostgreSQL database to a target PostgreSQL server.

Continue reading