TPAexec is an orchestration tool that uses Ansible to build Postgres clusters that follow Trusted Postgres Architecture (TPA). TPA basically includes a set of recommendations from 2ndQuadrant about how to set up a Postgres cluster in various scenarios. These represent the best practices followed by 2ndQuadrant, and are as applicable to quick testbed setups as […]
I don’t often get to speak on technical topics, but the video of my presentation below covers various concepts around “Ansible and PostgreSQL” – something I am very enthusiastic about. This presentation covers the following topics: Overview of Ansible and PostgreSQL Best strategies for mixed cloud and on-premises deployments How to deploy AlwaysOn PostgreSQL clusters […]
PostgreSQL administration, configuration, and deployment can be a tough ask while working in an agile environment with strict deadlines. The key to simplify these operational tasks for PostgreSQL is Ansible – an open source IT automation tool. To explain how these technologies work together, 2ndQuadrant hosted a Webinar on PostgreSQL deployments using Ansible. The webinar […]
I’ve started to write about the tool (pglupgrade) that I developed to perform near-zero downtime automated upgrades of PostgreSQL clusters. In this post, I’ll be talking about the tool and discuss its design details. You can check the first part of the series here: Near-Zero Downtime Automated Upgrades of PostgreSQL Clusters in Cloud (Part I). The tool is […]
Last week, I was at Nordic PGDay 2018 and I had quite a few conversations about the tool that I wrote, namely pglupgrade, to automate PostgreSQL major version upgrades in a replication cluster setup. I was quite happy that it has been heard and some other people in different communities giving talks at meetups and other […]
The second edition of the 5432…MeetUs! conference is sure to be one to remember. They will be hosting PostgreSQL experts, users, and contributors from all over the world. With talks, workshops, and trainings – we are sure to stay busy every minute! With speakers like Zalando’s Valentine Gogichasvili and IBM’s Andrea Vercellini, it will be […]
Ansible Galaxy is simply the easiest way of finding already written Ansible roles, creating and sharing your roles and jump into the galaxy of Ansible content!
Ansible is simply great and PostgreSQL is surely awesome, let’s see how they work amazingly together!