ANXS/postgresql
Fork: 576 Star: 855 (更新于 2024-10-29 17:59:39)
license: MIT
Language: Jinja .
Fairly full featured Ansible role for Postgresql.
最后发布版本: v1.16.0 ( 2024-01-23 17:21:23)
ANXS - PostgreSQL
Help Wanted! If you are able and willing to help maintain this Ansible role then please open a GitHub issue. A lot of people seem to use this role and we (quite obviously) need assistance! 💖
Ansible role which installs and configures PostgreSQL, extensions, databases and users.
Installation
This has been tested on Ansible 2.4.0 and higher.
To install:
ansible-galaxy install anxs.postgresql
Example Playbook
An example how to include this role:
---
- hosts: postgresql-server
roles:
- role: ANXS.postgresql
become: yes
An example how to include this role as a task:
---
- hosts: postgresql-server
tasks:
- block: # workaround, see https://stackoverflow.com/a/56558842
- name: PSQL installation and configuration
include_role:
name: ANXS.postgresql
vars:
postgresql_users:
- name: abc
password: abc
become: true
Dependencies
- ANXS.monit (Galaxy/GH) if you want monit protection (in that case, you should set
monit_protection: true
)
Compatibility matrix
Distribution / PostgreSQL | 11 | 12 | 13 | 14 | 15 | 16 |
---|---|---|---|---|---|---|
Debian 11.x | :no_entry: | :white_check_mark: | :white_check_mark: | :white_check_mark: | :white_check_mark: | :white_check_mark: |
Debian 12.x | :no_entry: | :white_check_mark: | :white_check_mark: | :white_check_mark: | :white_check_mark: | :white_check_mark: |
Rockylinux 8.x | :no_entry: | :warning: | :warning: | :warning: | :warning: | :warning: |
Rockylinux 9.x | :no_entry: | :white_check_mark: | :white_check_mark: | :white_check_mark: | :white_check_mark: | :white_check_mark: |
Ubuntu 20.04.x | :no_entry: | :white_check_mark: | :white_check_mark: | :white_check_mark: | :white_check_mark: | :white_check_mark: |
Ubuntu 22.04.x | :no_entry: | :white_check_mark: | :white_check_mark: | :white_check_mark: | :white_check_mark: | :white_check_mark: |
- :white_check_mark: - works fine
- :warning: - has known issues
- :no_entry: - is unsupported and/or EOL
Variables
# Basic settings
postgresql_version: 16
postgresql_encoding: "UTF-8"
postgresql_locale: "en_US.UTF-8"
postgresql_ctype: "en_US.UTF-8"
postgresql_admin_user: "postgres"
postgresql_default_auth_method: "peer"
postgresql_cluster_name: main
postgresql_cluster_reset: false
# List of databases to be created (optional)
# Note: for more flexibility with extensions use the postgresql_database_extensions setting.
postgresql_databases:
- name: foobar
owner: baz # optional; specify the owner of the database
hstore: yes # flag to install the hstore extension on this database (yes/no)
uuid_ossp: yes # flag to install the uuid-ossp extension on this database (yes/no)
citext: yes # flag to install the citext extension on this database (yes/no)
encoding: "UTF-8" # override global {{ postgresql_encoding }} variable per database
state: "present" # optional; one of 'present', 'absent', 'dump', 'restore'
lc_collate: "en_GB.UTF-8" # override global {{ postgresql_locale }} variable per database
lc_ctype: "en_GB.UTF-8" # override global {{ postgresql_ctype }} variable per database
# List of database extensions to be created (optional)
postgresql_database_extensions:
- db: foobar
extensions:
- hstore
- citext
# List of users to be created (optional)
postgresql_users:
- name: baz
pass: pass
encrypted: yes # if password should be encrypted, postgresql >= 10 does only accepts encrypted passwords
state: "present" # optional; one of 'present', 'absent'
# List of schemas to be created (optional)
postgresql_database_schemas:
- database: foobar # database name
schema: acme # schema name
state: present
- database: foobar # database name
schema: acme_baz # schema name
owner: baz # owner name
state: present
# List of user privileges to be applied (optional)
postgresql_user_privileges:
- name: baz # user name
db: foobar # database
priv: "ALL" # privilege string format: example: INSERT,UPDATE/table:SELECT/anothertable:ALL
role_attr_flags: "CREATEDB" # role attribute flags
There's a lot more knobs and bolts to set, which you can find in the defaults/main.yml
Testing - Molecule
This project comes with a molecule configuration. Please see ./molecule/README.md
Examples:
molecule test
Testing - Vagrant
This project comes with a Vagrantfile, this is a fast and easy way to test changes to the role, fire it up with vagrant up
See vagrant docs for getting setup with vagrant
Once your VM is up, you can reprovision it using either vagrant provision
, or ansible-playbook tests/playbook.yml -i vagrant-inventory
If you want to toy with the test play, see tests/playbook.yml, and change the variables in tests/vars.yml
If you are contributing, please first test your changes within the vagrant environment, (using the targeted distribution), and if possible, ensure your change is covered in the tests found in .travis.yml
License
Licensed under the MIT License. See the LICENSE file for details.
Thanks
Creator:
Maintainers:
Top Contributors:
- David Farrington
- Jesse Lang
- Michael Conrad
- Sébastien Alix
- Copperfield
- T. Soulabail
- Ralph von der Heyden
Feedback, bug-reports, requests, ...
Are welcome!
最近版本更新:(数据更新于 2024-09-16 21:39:49)
2024-01-23 17:21:23 v1.16.0
2023-12-12 01:23:15 v1.15.0
2023-11-27 17:28:27 v1.14.2
2023-08-25 15:42:23 v1.14.1
2023-07-28 22:25:41 v1.14.0
2019-11-07 19:53:34 v1.12.0
2019-04-24 20:28:16 v1.11.1
2019-04-08 18:24:27 v1.11.0
2018-04-23 23:49:56 v1.10.1
2018-03-26 23:53:38 v1.10.0
主题(topics):
ansible, ansible-role, postgresql
ANXS/postgresql同语言 Jinja最近更新仓库
2024-09-11 20:29:37 hassio-addons/addon-adguard-home
2024-08-11 02:42:05 netbootxyz/netboot.xyz
2024-07-03 05:53:58 ansible/awx-operator
2023-11-07 01:10:20 kubernetes-sigs/kubespray
2022-08-22 21:29:48 lsgalves/ansible-role-ipban
2019-07-31 23:45:16 trailofbits/algo