Presented by:

6e669a68aee7cfab192e29da07f8a931

Robert

from Zonar Systems

First introduced to hangman on a mini computer playing the William Tell Overture, Robert is a very "old?" school hacker.

Robert discovered Linux after completing several years of much needed therapy overcoming the trauma of programming using punchcards. Eventually, he focused his open source activities on PostgreSQL and has since then worked in everything from mom and pop companies to fortune 50 companies. He has had the singular honor of conducting training at the famed Los Alamos National Laboratory.

After working several years in California's Silicon Valley, he returned to the Pacific Northwest to experience real weather. These days, he is the senior DBA at Zonar Systems, working in the heart of Seattle's downtown core.

**

2019-04-27: I've uploaded the scripts and slides on gitlab

        https://gitlab.com/rbernier/linuxfest-2019-all-about-barman

**

The PostgreSQL ecosystem is incredibly sophisticated. At one time the only thing a PostgreSQL DBA had to worry about was to master this opensource database engine and leverage his knowledge of the operating system. Well, times have changed. The world for the DBA has expanded such that now he has to think in terms of whole clusters of database farms with all the requisite minutia of tasks including backups and disaster recovery on an ever increasing scale and that's not even talking about the cloud.

This talk focuses on what is becoming a very important requisite piece of technology called Barman.

Barman (Backup and Recovery Manager) is an open-source administration tool for disaster recovery of PostgreSQL servers written in Python. It allows your organisation to perform remote backups of multiple servers in business critical environments to reduce risk and help DBAs during the recovery phase.

I will cover the installation of Barman and how it can be used in conjunction with PostgreSQL. Such tasks as backups, restoration, replication, disaster recovery will be covered. Frankly, it's a very impressive piece of software because it simplifies a lot of tasks that were at one time manually managed by the DBA.

Date:
Duration:
45 min
Room:
HC-103 Postgres
Conference:
LinuxFest Northwest 2019
Language:
Track:
Postgres Track
Difficulty:
Medium

Happening at the same time:

  1. Steganography - Hiding In Plain Sight
  2. Start Time:
    2019 April 28 10:45

    Room:
    CC-114

  3. What Was Old is New Again
  4. Start Time:
    2019 April 28 10:45

    Room:
    CC-208

  5. Lambda Calculus for the Practicing Programmer
  6. Start Time:
    2019 April 28 10:45

    Room:
    HC-104 Jupiter

  7. Paradux: Recovering From Maximum Personal Data Disaster
  8. Start Time:
    2019 April 28 10:45

    Room:
    HC-108

  9. Sex, Secret and God: A Brief History of Bad Passwords
  10. Start Time:
    2019 April 28 10:45

    Room:
    G-103

  11. Past, Present & Future of Blockchain
  12. Start Time:
    2019 April 28 10:45

    Room:
    CC-235

  13. We can fix email server encryption!
  14. Start Time:
    2019 April 28 10:45

    Room:
    CC-200

  15. CompTIA's NEW Linux+ Certification - All You Need to Know!
  16. Start Time:
    2019 April 28 10:45

    Room:
    CC-115

  17. Introducing Snaps and Snapcraft
  18. Start Time:
    2019 April 28 10:45

    Room:
    CC-202 Tutorials

  19. PostgreSQL: An Introduction to BARMAN
  20. Start Time:
    2019 April 28 10:45

    Room:
    HC-103 Postgres

  21. Web of Things API
  22. Start Time:
    2019 April 28 10:45

    Room:
    CC-236