PostgreSQL

Automating PostgreSQL Configuration with Ansible Setting Maximum Connections

December 10, 2023
Posted by Luca Berton
PostgreSQL, Ansible, Automation, Database Management, Configuration Management, Infrastructure as Code, DevOps, System Administration, Playbooks, Database Optimization, Open Source, Relational Databases, IT Automation, Scalability, Performance Tuning, Server Management, Scripting, DevOps Tools, Deployment Automation

Introduction PostgreSQL, a powerful open-source relational database management system, is widely used in various applications to store and manage data.

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).

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.

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.

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.

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.

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.

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?

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?

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.

Ansible for PostgreSQL: PGMeetUp Bari 2022 Highlights

June 8, 2022
Posted by Luca Berton
ansible, news, conference, community, virtual, PostgreSQL

TL;DR: Ansible For PostgreSQL - PGMeetUp Bari 10 June 2022 conference Save the date!

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.

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.

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.