postgresql
postgresql copied to clipboard
ANXS
Fairly full featured Ansible role for Postgresql.
I believe that default Ident mapping should be like this ``` diff # pg_ident.conf postgresql_pg_ident: - comment: "root is allowed to login as {{ postgresql_admin_user }}" mapname: "root_as_{{ postgresql_admin_user }}"...
Hi, Is there something to manage replication ? do you plan to accept PR for that ? Thank you.
http://docs.ansible.com/ansible/postgresql_privs_module.html It'd be more expressive/convenient to use this rather than the `postgresql_user` module for managing user privileges: https://github.com/ANXS/postgresql/blob/master/tasks/users_privileges.yml#L4 It's an Ansible core module, so should be supported by them.
ansible_python_interpreter is empty unless it is set explicitly therefore it is not reliable way of knowing which version of python is used on remote host. Using binary name to know...
I am in the process of migration a few machines to Ubuntu 20. I get the following error: ``` TASK [ANXS.postgresql : PostgreSQL | Extensions | Make sure the postgis...
My proposal to fix issue #464 I renamed all role internal `vars` with double underscore prefix, and set values in `defaults/main.yml`. I also remove unnecessary version specific files as they...
Postgres server port value specified in test playbook referred as documentation can cause headaches
Hello, just a friendly feedback : it took me an unusually long time to figure out why `psql` couldn't connect to a PG server deployed using values taken in tests/vars.yml....
This is pretty rudimentary, but it allows installing the Postgres 10 or Postgres 9.6 repositories (provided by Amazon). Does not work, however if any other version is specified. Would be...
So I noticed at the first play (CentOS) that configuration settings were not applied because systemd applied settings from data dir instead of /etc: ```[root@dbserver ~]# systemctl status postgresql-11.service ●...
