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.
PostgreSQL Tutorial: Backing up a database cluster using pg_basebackup
Summary: pg_basebackup is the built-in binary format backup tool available with PostgreSQL. Only the backups taken using pg_basebackup can be used for point-in-time recovery and not pg_dump or pg_dumpall.
PostgreSQL Tutorial: Restoring a backup taken using pg_basebackup
Summary: In the backing up a database cluster tutorial, we discussed how pg_basebackup can be used to take a physical backup of the PostgreSQL cluster. We may restore this backup in various situations, such as creating a standby server in replication or recovering a database to a point in time. In this tutorial, we shall see the steps required to restore a backup taken using pg_basebackup.
PostgreSQL Tutorial: Minor Version Update
Summary: In this tutorial, we shall see how a minor version upgrade can be performed when using PostgreSQL 13.