Special

Introducing the “Welcome to Xojo” Bundle!

New to Xojo and looking for guidance? We've put together a terrific bundle to welcome you! Xojo Bundle

This bundle includes six back issues of the magazine -- all of year 21 in printed book and digital formats -- plus a one-year subscription (beginning with 22.1) so you'll be learning all about Xojo for the next year. It's the perfect way to get started programming with Xojo. And you save as much as $35 over the non-bundle price!

This offer is only available for a limited time as supplies are limited, so hurry today and order this special bundle before the offer goes away!

Article Preview


Buy Now

Issue 16.2 ('StockScripter')
Instant purchase and download via GumRoad!

COLUMN

A Backup and Recovery Approach

PostgreSQL Continuous Archiving and Point-in-Time Recovery (PITR)

Issue: 16.2 (March/April 2018)
Author: Craig Boyd
Author Bio: Craig Boyd is currently a data architect for a major fashion retail brand. But in his 23 years of IT experience, he has been everything from a PC Technician, iSeries System Administrator, iSeries Programmer, Sr. Technical Lead, Data Modeler, Data Architect, Oracle DBA, BI Consultant and Solution Architect. He lives in the great state of Texas with his wife and two kids.
Article Description: No description available.
Article Length (in bytes): 16,903
Starting Page Number: 91
Article Number: 16208
Related Link(s): None

Excerpt of article text...

In the last column we began our discussion of Barman and very lightly touched on the topic of disaster recovery. In this column we are going to begin our preparatory work for installing and setting up Barman by setting up and configuring continuous archiving.

In next month's column we will actually test our continuous archiving by doing a point-in-time recovery (PITR).

As with my previous columns all the same caveats and encouragements apply:

  • An untested backup is no backup at all

  • Test your backups by doing actual restores

  • Do the appropriate thing for your environment(s). If you don't need this level of disaster recovery then by all means keep it simple.

...End of Excerpt. Please purchase the magazine to read the full article.