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 15 in printed book and digital formats -- plus a one-year subscription 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.4 ('Mojave')
Instant purchase and download via GumRoad!

COLUMN

A Backup and Recovery Approach

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

Issue: 16.4 (July/August 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): 10,715
Starting Page Number: 85
Article Number: 16406
Related Link(s): None

Excerpt of article text...

Hello All! We have finally arrived at the point in time when we actually install and use Barman the PostgreSQL server backup and restore utility. All my usual caveats apply here about testing and believing the documentation and testing some more.

I do have to start here with a brief apology: I could not get the latest version, 2.4, working in time for me to write this article so I had to fall back to the version that came with my Linux distribution, 1.5.1. I know that is a healthy difference so I will try to address this at some point in the future. Again, I am very sorry.

In spite of my apology, I do feel like this column should at least give you a taste for the power and advantages of using a tool like Barman. Some of those advantages include, but are not limited to:

  • A centralized repository for your backups

  • The ability to control those backups from a single spot

  • Perform PITR (Point-In-Time-Recovery) more easily from a single spot

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