O'Reilly logo

Troubleshooting PostgreSQL by Hans-Jürgen Schönig

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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.

Using pg_dump

The pg_dump command is one of the most important commands in PostgreSQL. It can be used to create textual as well as binary backups. Every system administrator will get in touch with this command once in a while. Here is how it works.

Creating textual ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required