Ansible

Foreign Data Wrappers

Using foreign data wrappers to combine metrics across a distributed database cluster

Valerie Parham-Thompson
Ansible, Automation, Distributed-Systems, Postgres, Queries, Rdbms, Yugabytedb
I was recently setting up a demo to show off query logging features. Two common extensions, pg_stat_statements and pg_stat_monitor, store data locally. In the case of a distributed database, it is helpful to combine the query runtimes on all nodes.

Provision Ansible Postgres on Mac

Using Ansible to create a local testing environment for Postgres on Mac

Valerie Parham-Thompson
Ansible, Automation, Data-Migration, Postgres, Rdbms
I added a new database to my demo platform: Postgres. This code helps me provision Ansible Postgres on Mac for demo purposes or simple functional testing, and it is an extension of previous work I shared: https://valerieparhamthompson.com/posts/string-search/.