database

Automate PostgreSQL Database Management with Ansible

April 26, 2023
Posted by Luca Berton
ansible, book, course, training, resource, database, PostgreSQL

Introduction Automating your database (PostgreSQL) with Ansible enables you to achieve Infrastructure as Code (IaC).

Continue reading

Run a SQL Command/Query on PostgreSQL - Ansible module postgresql_query

June 18, 2022
Posted by Luca Berton
ansible, database, module, postgresql_query, sql, PostgreSQL, query, command, version, table

How to Run a SQL Command/Query on PostgreSQL with Ansible? I’m going to show you a live Playbook with some simple Ansible code.

Continue reading

Rename a PostgreSQL Database - Ansible module postgresql_db

June 16, 2022
Posted by Luca Berton
ansible, database, module, postgresql_db, Rename, PostgreSQL, db

How to Rename a PostgreSQL Database with Ansible? I’m going to show you a live Playbook with some simple Ansible code.

Continue reading

Drop a PostgreSQL Database - Ansible module postgresql_db

June 15, 2022
Posted by Luca Berton
ansible, database, module, postgresql_db, Drop, PostgreSQL, db

How to Drop a PostgreSQL Database with Ansible? I’m going to show you a live Playbook with some simple Ansible code.

Continue reading

Automate PostgreSQL Backups with Ansible Playbook

June 13, 2022
Posted by Luca Berton
ansible, database, module, postgresql_db, backup, PostgreSQL, db, dump

How to Backup a PostgreSQL Database with Ansible? I’m going to show you a live Playbook with some simple Ansible code.

Continue reading

Restore a PostgreSQL Database — Ansible module postgresql_db

June 13, 2022
Posted by Luca Berton
ansible, database, module, postgresql_db, backup, PostgreSQL, db, dump, restore

How to Restore a PostgreSQL Database with Ansible? I’m going to show you a live Playbook with some simple Ansible code.

Continue reading

Grant Privileges to User/Role on PostgreSQL Database - Ansible module postgresql_privs

June 10, 2022
Posted by Luca Berton
ansible, database, module, postgresql_privs, permission, PostgreSQL, db,

How to Grant Privileges to User/Role on PostgreSQL Database with Ansible?

Continue reading

Configure PostgreSQL with Ansible: User Access and Service Management

June 9, 2022
Posted by Luca Berton
ansible, database, module, postgresql_user, authentication, PostgreSQL, user, role, md5

How to Allow md5 Connection for a PostgreSQL User / Role with Ansible?

Continue reading

Create PostgreSQL Users/Roles with Ansible: A Simple Guide

June 9, 2022
Posted by Luca Berton
ansible, database, module, postgresql_user, create, PostgreSQL, user, role

How to Create a PostgreSQL User / Role with Ansible? I’m going to show you a live Playbook with some simple Ansible code.

Continue reading

Create PostgreSQL Databases with Ansible: Easy Guide

June 8, 2022
Posted by Luca Berton
ansible, database, module, postgresql_db, create, PostgreSQL, db

How to Create a PostgreSQL Database with Ansible? I’m going to show you a live Playbook with some simple Ansible code.

Continue reading

Install PostgreSQL in Debian-like systems - Ansible modules apt, stat, shell, service

June 8, 2022
Posted by Luca Berton
ansible, apt, module, deb, Ubuntu, PostgreSQL, database, debian

How to Install PostgreSQL with Ansible in RedHat-like systems? I’m going to show you a live Playbook and some simple Ansible code.

Continue reading

Install PostgreSQL in RedHat-like systems - Ansible modules yum, stat, shell, service

June 6, 2022
Posted by Luca Berton
ansible, yum, module, DNF, RedHat, PostgreSQL, database

How to Install PostgreSQL with Ansible in RedHat-like systems? I’m going to show you a live Playbook and some simple Ansible code.

Continue reading