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
How to perform maintenance updates
How to create a variety of cluster types
How to backup servers for mixed on-premises and multi-cloud deployments
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 was presented by Tom Kincaid, GM North America at 2ndQuadrant, who gave an overview of Ansible and PostgreSQL, covered best strategies for deployments, and a variety of other topics.
If you weren’t able to make it to the live session, you can now view the recording here.
For any questions, comments, or feedback, please visit our website or send an email to [email protected](more…)
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 written in Ansible. I have prior experience of working with Ansible, and I currently work with it in 2ndQuadrant as well, which is why it was a comfortable option for me. That being said, you can implement the minimal downtime upgrade logic, which will be explained later in this post, with your favorite automation tool.
Further reading: Blog posts Ansible Loves PostgreSQL , PostgreSQL Planet in Ansible Galaxy and (more…)
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 conferences about near-zero downtime upgrades using logical replication. Given that there is a talk that I gave at PGDAY'17 Russia, PGConf.EU 2017 in Warsaw and lastly at FOSDEM PGDay 2018 in Brussels, I thought it is better to create a blog post to keep this presentation available to the folks who could not make it to any of the conferences aforementioned. If you would like to directly go the talk and skip reading this blog post here is your link: Near-Zero Downtime (more…)
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 great to be in good company with fellow PostgreSQL supporters and hear real life case studies of individuals who have successfully applied PostgreSQL and Open Source practices and tools within their enterprises.
In addition to the independent developers, other companies we look forward to catching up with at the event include Dalibo, Subito.it, Navionics, InnoGames, PaxLife, and more.
Check out who all will be in attendance!