Ansible For PostgreSQL by Examples
$8.99
Minimum price
$12.99
Suggested price

Ansible For PostgreSQL by Examples

10+ Examples To Automate Your PostgreSQL database

About the Book

Learn the Ansible automation technology with some real-life examples.

Every successful IT department needs automation nowadays for bare metal servers, virtual machines, could, containers, and edge computing. Automate your IT journey with Ansible automation technology.

I'm going to teach you example by example how to accomplish the most common Dabatse Administrator tasks.

Each of the lessons summarizes a module: from the most important parameter to some live demo of code and real-life usage. Each code is battle proved in the real life. Console interaction and verification are included in every lesson. Mundane activities like installing the database management system in Red Hat (Red Hat Enterprise Linux, CentOS, Amazon Linux, AlmaLinux, Rocky Linux, etc.) and Debian (Ubuntu, Scientific Linux) like systems, creating a database file, creating a user, granting the permission to a user to connect to the database, backup ad restore a single database could be automated with some lines of code and these are only some of the long lists included in the course.

There are some Ansible codes usable in all the Linux systems, some specific for RedHat-like, Debian-like systems.

The Ansible troubleshooting lesson teaches you how to read the error message, how to reproduce it, and the process of troubleshooting and resolution.

Are you ready to automate your day with Ansible?

Examples in the book are tested with the latest version of Ansible 2.9+ and Ansible Core 2.11+.

About the Author

Luca Berton
Luca Berton

Luca Berton is an Ansible Automation Expert who has been working with JPMorgan Chase & Co. and previously worked with the Red Hat Hat Ansible Engineer Team for three years. Published author of the Ansible for VMware by Examples and Ansible for Kubernetes by Examples best-seller of the Ansible By Example(s) practical book series and creator of the Ansible Pilot project. With more than 15 years of experience as a System Administrator, he has strong expertise in Infrastructure Hardening and Automation. Enthusiast of the Open Source supports the community, sharing his knowledge in different events of public access. Geek by nature, Linux by choice, Fedora, of course.

Table of Contents

  • Introduction
    • Modern IT Infrastructure
    • Whois Luca Berton
  • Ansible For Beginners With Examples
    • What is Ansible
    • Getting Started
    • Inventory
    • Playbook
    • Variables
    • Facts and Magic Variables
    • Vault
    • Conditional
    • Loop
    • Handler
    • Role
    • Ansible Best Practices
  • Install Ansible
    • Ansible terminology - ansible vs ansible-core packages
    • How to install Ansible in RedHat Enterprise Linux (RHEL) 8 with Ansible Engine
    • How to install Ansible in Ubuntu 22.04 LTS
    • How to install Ansible in Fedora 36 - Ansible install
    • How to install Ansible in CentOS 9 Stream
    • How to install Ansible in Windows 11 WSL Windows Subsystem for Linux
    • How to install Ansible in macOS - Ansible install
    • How to install Ansible in SUSE Linux Enterprise Server (SLES) 15 SP3
    • How to install Ansible with PIP
    • How to install Ansible in RedHat Enterprise Linux (RHEL) 9 - Ansible install
    • How to install Ansible in Amazon Linux 2 (AWS EC2)
    • How to install Ansible in Debian 11
  • Ansible For PostgreSQL
    • Install PostgreSQL in RedHat-like systems - Ansible modules yum, stat, shell, service
    • Install PostgreSQL in Debian-like systems - Ansible modules apt, stat, shell, service
    • Create a PostgreSQL Database - Ansible module postgresql_db
    • Drop a PostgreSQL Database - Ansible module postgresql_db
    • Rename a PostgreSQL Database - Ansible module postgresql_db
    • Create a PostgreSQL User or Role - Ansible module postgresql_user
    • Allow md5 Connection for a PostgreSQL User / Role - Ansible module postgresql_pg_hba
    • Grant Privileges to User/Role on PostgreSQL Database - Ansible module postgresql_privs
    • Backup a PostgreSQL Database - Ansible module postgresql_db
    • Restore a PostgreSQL Database — Ansible module postgresql_db
    • Run a SQL Command/Query on PostgreSQL - Ansible module postgresql_query
  • Thank you

The Leanpub 60 Day 100% Happiness Guarantee

Within 60 days of purchase you can get a 100% refund on any Leanpub purchase, in two clicks.

Now, this is technically risky for us, since you'll have the book or course files either way. But we're so confident in our products and services, and in our authors and readers, that we're happy to offer a full money back guarantee for everything we sell.

You can only find out how good something is by trying it, and because of our 100% money back guarantee there's literally no risk to do so!

So, there's no reason not to click the Add to Cart button, is there?

See full terms...

80% Royalties. Earn $16 on a $20 book.

We pay 80% royalties. That's not a typo: you earn $16 on a $20 sale. If we sell 5000 non-refunded copies of your book or course for $20, you'll earn $80,000.

(Yes, some authors have already earned much more than that on Leanpub.)

In fact, authors have earnedover $13 millionwriting, publishing and selling on Leanpub.

Learn more about writing on Leanpub

Free Updates. DRM Free.

If you buy a Leanpub book, you get free updates for as long as the author updates the book! Many authors use Leanpub to publish their books in-progress, while they are writing them. All readers get free updates, regardless of when they bought the book or how much they paid (including free).

Most Leanpub books are available in PDF (for computers) and EPUB (for phones, tablets and Kindle). The formats that a book includes are shown at the top right corner of this page.

Finally, Leanpub books don't have any DRM copy-protection nonsense, so you can easily read them on any supported device.

Learn more about Leanpub's ebook formats and where to read them

Write and Publish on Leanpub

You can use Leanpub to easily write, publish and sell in-progress and completed ebooks and online courses!

Leanpub is a powerful platform for serious authors, combining a simple, elegant writing and publishing workflow with a store focused on selling in-progress ebooks.

Leanpub is a magical typewriter for authors: just write in plain text, and to publish your ebook, just click a button. (Or, if you are producing your ebook your own way, you can even upload your own PDF and/or EPUB files and then publish with one click!) It really is that easy.

Learn more about writing on Leanpub