PostgreSQL External Projects

ora_migrator: Oracle to PostgreSQL migration tools

Summary: ora_migrator is a plugin for db_migrator that uses oracle_fdw to migrate an Oracle database to PostgreSQL.

Continue reading

pg_gather: SQL script for PostgreSQL health inspection

Summary: Scan PostgreSQL instance for potential problems. pg_gather is a SQL-only script leveraging the built-in features of psql.

Continue reading

pg_repack: Reorganize tables with minimal locks

Summary: pg_repack is a PostgreSQL extension which lets you remove bloat from tables and indexes, and optionally restore the physical order of clustered indexes.

Continue reading

plpgsql_check: PL/pgSQL source code static checker

Summary: The plpgsql_check extension is a linter tool that does source code static analyze for the PostgreSQL PL/pgSQL language, which is a native language for PostgreSQL stored procedures.

Continue reading

oracle_fdw: Foreign Data Wrapper for Oracle

Summary: oracle_fdw is a PostgreSQL extension that provides a Foreign Data Wrapper for easy and efficient access to Oracle databases, including pushdown of WHERE conditions and required columns as well as comprehensive EXPLAIN support.

Continue reading

pg_wait_sampling: Sampling based statistics of wait events

Summary: The pg_wait_sampling extension exposes a lot of sampling based statistics of wait events that will be helpful for optimizing PostgreSQL database.

Continue reading