postgresql
postgresql copied to clipboard
ANXS
Fairly full featured Ansible role for Postgresql.
Hello, First thanks for your ansible projet ! I noticed that postgresql configuration changes between version can be really painful to manage. In order to better manage postgresql current and...
Hi All, When running the role against a RHEL7 host (not CentOS) the role fails when performing the following task: ``` - name: PostgreSQL | Install all the required dependencies...
Hi, For installation of some other package i'm missing the postgresql-server-dev-(version) on debian. Currently adding it via the playbook but not ideal when changing postgres versions. Probaly as simple by...
This PR changes the postgresql.conf row_security setting to 'on'. WHY: The default installs of PostgreSQL after 9.5 from the PostgreSQL repositories all have row_security defaulting to on. This is also...
Fixes #251, and gives sensible defaults (the latest version) of PostGIS for each different version of PostgreSQL I've also added the extension to the travis tests, so it should get...
If the database crashes, then during crash recovery it looks for pg_ident.conf... and fails: ``` 2018-03-20 15:07:25 UTC [11965]: [3-1] user=,db=,app=,client= LOG: could not open usermap file "/etc/postgresql/9.6/data/pg_ident.conf": No such...
I tried changing the data directory on a ubuntu install, and it failed miserably, read the playbook. only supported on redhat.
Currently RedHat is limited to a single cluster, by overriding the `{{ postgresql_cluster_name }}` with `data`. This was done to work within the SELinux restrictions, but my testing shows that...