Database

Automate PostgreSQL with Ansible for Efficient IaC

Automate PostgreSQL with Ansible for Efficient IaC

Learn how to automate PostgreSQL database tasks using Ansible. From installation to backup and user management, streamline your workflow and CI/CD pipelines efficiently.

#ansible #book #course #training #resource #database #postgresql

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

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

How to automate the running of SQL Query / Command in a “testdb” database on PostgreSQL using Ansible Playbook and postgresql_query module.

#ansible #database #module #postgresql_query #sql #postgresql #query #command #version #table

Rename a PostgreSQL Database - Ansible module postgresql_db

Rename a PostgreSQL Database - Ansible module postgresql_db

How to automate the delete of a "testdb" database on PostgreSQL using Ansible Playbook and postgresql_db module.

#ansible #database #module #postgresql_db #rename #postgresql #db

Drop a PostgreSQL Database - Ansible module postgresql_db

Drop a PostgreSQL Database - Ansible module postgresql_db

How to automate the delete of a "testdb" database on PostgreSQL using Ansible Playbook and postgresql_db module.

#ansible #database #module #postgresql_db #drop #postgresql #db

Restore a PostgreSQL Database — Ansible module postgresql_db

Restore a PostgreSQL Database — Ansible module postgresql_db

How to automate the restore of a backup file of a “testdb” database on PostgreSQL using Ansible Playbook and postgresql_db module.

#ansible #database #module #postgresql_db #backup #postgresql #db #dump #restore

Backup a PostgreSQL Database - Ansible module postgresql_db

Backup a PostgreSQL Database - Ansible module postgresql_db

How to automate the backup of a “testdb” database on PostgreSQL using Ansible Playbook and postgresql_db module.

#ansible #database #module #postgresql_db #backup #postgresql #db #dump

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

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

How to automate the granting of all permission for "myuser" user/role on database "testdb" on PostgreSQL using Ansible Playbook and postgresql_privs module.

#ansible #database #module #postgresql_privs #permission #postgresql #db #

Create a PostgreSQL User or Role - Ansible module postgresql_user

Create a PostgreSQL User or Role - Ansible module postgresql_user

How to automate the creation of a “myuser” user/role on PostgreSQL using Ansible Playbook and postgresql_user module.

#ansible #database #module #postgresql_user #create #postgresql #user #role

Allow md5 Connection for a PostgreSQL User / Role - Ansible module postgresql_pg_hba

Allow md5 Connection for a PostgreSQL User / Role - Ansible module postgresql_pg_hba

How to automate the creation of a PostgreSQL authentication file pg_hba.conf to allow the “myuser” user/role to connect using md5 authentication on PostgreSQL using Ansible Playbook and postgresql_pg_hba module.

#ansible #database #module #postgresql_user #authentication #postgresql #user #role #md5

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

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

How to automate the installation of PostgreSQL on Debian-like systems: installing the necessary packages and dependency, initializing the configuration, starting and enabling service on boot using Ansible Playbook and apt, stat, shell, and service modules.

#ansible #apt #module #deb #ubuntu #postgresql #database #debian

Create a PostgreSQL Database - Ansible module postgresql_db

Create a PostgreSQL Database - Ansible module postgresql_db

How to automate the creation of a "testdb" database on PostgreSQL using Ansible Playbook and postgresql_db module.

#ansible #database #module #postgresql_db #create #postgresql #db

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

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

How to automate the installation of PostgreSQL on RedHat-like systems: installing the necessary packages and dependency, initializing the configuration, starting and enabling service on boot using Ansible Playbook and yum, stat, shell, and service modules.

#ansible #yum #module #dnf #redhat #postgresql #database

Pluralsight

Apress by Springer Nature

Ansible Anwender

Red Hat Security Bulletin

ansible bullhorn newsletter

Trustpilot

Follow me

Subscribe not to miss any new releases