O'Reilly logo

PostgreSQL 9 Administration Cookbook - Second Edition by Simon Riggs, Gianni Ciolli, Hannu Krosing, Gabriele Bartolini

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

Archiving transaction log data

Starting with PostgreSQL 9.2, streaming replication can send transaction log data to a remote node even if the node is not a full PostgreSQL server. This can be useful for archiving copies of transaction log data for various purposes.

PostgreSQL includes two client tools to stream data from the server to the client. The tools are designed using a "pull" model; that is, you run the tools on the node you wish the data to be saved on:

  • pg_receivexlog: This is available from PostgreSQL 9.2 onwards. It archives physical transaction log data (WAL files). This utility produces a straight copy of the original WAL files. Replication Slots are recommended when using this tool from 9.4 onwards.
  • pg_recvlogical: This is available ...

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