Greg Clough

Results 27 issues of Greg Clough

This isn't used anywhere, do we need to keep it? ``` [root@localhost postgresql]# grep -r postgresql_pgdg_releases * defaults/main.yml:postgresql_pgdg_releases: ```

stale

Use ansible_pgsql module

needs research
need help

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...

bug

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...

enhancement
stale

If any config change is made, then the cluster is "restarted". This will cause downtime and disconnect all sessions. Many config changes can be implemented with a "reload", which simply...

enhancement

We should support deployment to Amazon (AWS) linux distributions

question

The default location for `ssl_cert_file` and `ssl_key_file` is $PGDATA, and on RedHat I don't think we need the "snakeoil" key, so make a change so that RedHat uses the expected...

enhancement

We should support SUSE Linux Enterprise Server (SLES)

enhancement

Fixed #314 Looking around, there seems to have been some missing parameters and defaults. I've crosschecked them, and updated the ones I found. I believe this is a complete verification....