PostgreSQL Database

  1. Backup, Recovery, and Replication
    1. Backup Strategies
      1. SQL Dump
        1. pg_dump
          1. pg_dumpall
          2. File System Level Backup
            1. Cold Backup
              1. Hot Backup
              2. Continuous Archiving
                1. Point-in-Time Recovery
                2. Data Recovery
                  1. Restoring from pg_dump
                    1. Using psql
                      1. Using pg_restore
                      2. Performing Point-in-Time Recovery
                        1. Recovery Configuration
                          1. Recovery Target
                        2. Replication
                          1. Replication Concepts
                            1. Physical Replication
                              1. Logical Replication
                              2. Streaming Replication
                                1. Setting Up Streaming Replication
                                  1. Asynchronous Replication
                                    1. Synchronous Replication
                                      1. Monitoring Replication Status
                                      2. Logical Replication
                                        1. Publishers
                                          1. Subscribers
                                            1. Publication Setup
                                              1. Subscription Setup
                                                1. Use Cases for Logical Replication
                                                2. High Availability
                                                  1. Failover
                                                    1. Replication Slots
                                                      1. Monitoring Replication
                                                        1. Managing Replication

                                                    Previous

                                                    10. Database Administration

                                                    Go to top

                                                    Next

                                                    12. Advanced PostgreSQL Features