pgBadger: a fast PostgreSQL log analysis report
Summary: pgBadger is a tool, which can be used to generate log analysis report in PostgreSQL.
check_postgres: PostgreSQL monitoring script
Summary: check_postgres.pl is a PostgreSQL monitoring script for Nagios, MRTG, Cacti, and others.
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.
Use Navicat to compare and synchronize structure
Summary: Navicat compares objects between two databases and/or schemas and states the differences in structure, and synchronize the table structures and other objects.
Use Navicat to compare and synchronize data
Summary: Navicat provides the ability for data in different databases and/or schemas to be kept consistent so that each repository contains the same information.
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.
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.
PostgreSQL Tutorial: Enable WAL Archiving
Summary: in this tutorial, you will learn how to enable WAL archiving in PostgreSQL.
PostgreSQL Tutorial: Setting up Logical Replication
Summary: Built-in logical replication and logical decoding were introduced in PostgreSQL 10. Over a period of time, more and more features are being implemented within logical replication. It is helpful when a selected list of tables needs to be replicated from multiple OLTP databases to a single OLAP database for reporting and analysis.
PostgreSQL Tutorial: Setting up Streaming Replication
Summary: Streaming replication (physical replication), which is byte-by-byte replication, involves a continuous application of WAL records from Primary to Standby. As it uses a file-based log shipping method, it is one of the fastest replication methods when compared with logical replication or other trigger-based methods.