Greg Clough

feat(ANXS/postgresql): remove obsolete v9.6 and prior code

1

BREAKING CHANGE: v9.6 is no longer supported

As per #408 , find out why Fedora tests give this warning/error

2

As per #408 , find out why Fedora tests give this warning/error: ``` TASK [ANXS.postgresql : PostgreSQL | Ensure the locale is generated | RedHat] *** failed: [postgresql-9.6] (item={u'parts': [u'en_US',...

Fix PostGIS on PostgreSQL v12, as per #450

1

Fix PostGIS on PostgreSQL v12, as per #450. @thbar , help out if you can... after #450 is merged.

Allow multiple clusters on RedHat

3

Using multiple clusters in RedHat doesn't work, apparently due to SELinux. My testing shows that we can, so long as we use: `/var/lib/pgsql/{{ postgresql_version }}/{{ postgresql_cluster_name }}/data` By default this...

Update repo URL's with new format

1

This change will break the current repo URL generator: ``` Hi, I made 3 major changes in the PGDG RPM (RHEL/Fedora/CentOS/SL) repo files: 1. Instead of having separate repo RPMs...

Only restart the cluster when absolutely necessary, otherwise reload

20

Only restart the cluster when absolutely necessary, otherwise do a reload. Default to mega safety, and even if a restart is needed, then only do so if the "postgresql_restart_on_config_change" variable...

Convert ssl to redhat standard

12

Fixed #302 The default for RedHat (and PostgreSQL in general) is to put the key files into $PGDATA, so this patch follows that behaviour on RedHat, leaving Debian with the...

log_replication_commands parameter missing from v9.5, and v9.6

6

The `log_replication_commands` parameter is missing from the v9.5, and v9.6 configuration. It should be added to the `templates/postgresql.conf.9.[56].j2` files, and unless PR #267 is merged... then it should be added...

New structure to allow "tuning" during deploy without using pg_tune

11

This isn't 100% finished, but it's an example of how we can use Ansible to tune PostgreSQL without the use of pg_tune. When it's complete, it will be a fix...

Vagrant fails for "ubuntu/precise64"

1

When running Vagrant with "ubuntu/precise64", it fails: ``` fatal: [precise64.local]: FAILED! => { "changed": false, "module_stderr": "Shared connection to 192.168.88.29 closed.\r\n", "module_stdout": "Traceback (most recent call last):\r\n File \"/tmp/ansible_sK4yfH/ansible_module_apt_repository.py\", line...