Ansible modules for PostgreSQL - plain drop-in for your project.
If you ever had to install psycopg2, you've definitely came across that dependency hell: libraries, libraries and libraries - tons of them. This project nulls out said dependency hassle: everything works out-of-the-box, you don't have to install anything. The guest star here is "pg8000": pure-Python PostgreSQL driver, with minor modifications to support its loading and usage by Ansible.
- CentOS/RHEL 7.x;
- Ansible >=2.9.x;
- Python >=3.6.x;
- PostgreSQL >=10.x (this was debugged with Postgres 12, though)
-
Copy to your project directory:
- playbooks/library/*
- playbooks/module_utils/pg8000/*
- playbooks/module_utils/scramp/*
-
You're done, please don't forget to perform a wild dance (well, latter was a joke, just in case :-)
If you want to thank the author - this is a donate link. Any sum is happily accepted.
This project is conceived and performed by me, Sergey Pechenko, on my own will, out of working hours, using own hardware.
Copyright: (С) 2021, Sergey Pechenko
This project includes the changes in the "postgres.py" Ansible module, which has own copyright:
(c) Ted Timmons ted@timmons.me, 2017 (BSD-licensed)
Other Ansible modules included with or without my changes carry their own licenses and copyright - please see the exact module for author names
This project also uses MIT-licensed components as follows:
-
pg8000 (c) 2007-2009, Mathieu Fenniak
-
scramp (C) 2019 Tony Locke
Portions for these components that provide possibility for Ansible to load and run them are also (C) 2021, Sergey Pechenko.
GPLv3+ (please see LICENSE)
You can ask your questions about this plugin at the Ansible chat, or PM me