PostgreSQL Database

11.

Backup, Recovery, and Replication

11.1.

Backup Strategies

11.1.1.

11.1.1.1.

11.1.1.2.

11.1.2.

File System Level Backup

11.1.2.1.

11.1.2.2.

11.1.3.

Continuous Archiving

11.1.4.

Point-in-Time Recovery

11.2.

11.2.1.

Restoring from pg_dump

11.2.1.1.

11.2.1.2.

Using pg_restore

11.2.2.

Performing Point-in-Time Recovery

11.2.2.1.

Recovery Configuration

11.2.2.2.

Recovery Target

11.3.

11.3.1.

Replication Concepts

11.3.1.1.

Physical Replication

11.3.1.2.

Logical Replication

11.3.2.

Streaming Replication

11.3.2.1.

Setting Up Streaming Replication

11.3.2.2.

Asynchronous Replication

11.3.2.3.

Synchronous Replication

11.3.2.4.

Monitoring Replication Status

11.3.3.

Logical Replication

11.3.3.1.

11.3.3.2.

11.3.3.3.

Publication Setup

11.3.3.4.

Subscription Setup

11.3.3.5.

Use Cases for Logical Replication

11.3.4.

High Availability

11.3.4.1.

11.3.4.2.

Replication Slots

11.3.4.3.

Monitoring Replication

11.3.4.4.

Managing Replication

Previous

10. Database Administration

Go to top

Next

12. Advanced PostgreSQL Features