Book Image

Troubleshooting PostgreSQL

Book Image

Troubleshooting PostgreSQL

Overview of this book

Table of Contents (17 chapters)
Troubleshooting PostgreSQL
Credits
About the Author
About the Reviewers
www.PacktPub.com
Preface
Index

Chapter 8. Fixing Backups and Replication

In this chapter, you will be guided through replication and learn about simple, basic backups. The following topics will be covered:

  • Using pg_dump for text dumps

  • Creating custom format dumps

  • Performing binary base backups

  • Understanding point-in-time recovery

  • Setting up asynchronous replication

  • Upgrading to synchronous replication

This chapter provides a practical, straightforward introduction to backups and replication. The focus is on simple guidelines.