Greg Clough

Results 99 comments of Greg Clough

> No update for year. > And PostgreSQL 13 have been released. #504 pushed

> I'll be able to do bit of Postgres 13 testing later (simple install), because I have Ubuntu 16 -> 20 upgrades planned, and will likely group that, if this...

> I am preparing j2 templates for postgres13, I can push them back to community, if there is none any yet @barazbay , I think a lot of us had...

It seems that the original `pgtune` has been abandonded... but I did find a new project here: https://github.com/le0pard/pgtune It's not quite the same, so I don't know how much work...

I'm working on #301 , which should achieve the goals of pgtune... but purely in Ansible, and is compatible with later versions of PostgreSQL. It's not 100% tested yet, as...

The `gin_pending_list_limit` is also missing from v9.5 and v9.6.

I did some crosschecking using this script: ``` #!/bin/bash - TEMPFILE=/tmp/`basename $0`.$$ for FILE in postgresql.conf-[0-9]*\.orig; do BASE_FILE="`echo $FILE | sed s/\.orig\$//`" cat ${BASE_FILE}.orig | sed s/\#// | grep ^[a-z]...

I crosschecked them with the `defaults/main.yml`... and we're missing some in there too: *SCRIPT* ``` #!/bin/bash - # # Identify a unique filename # TEMP_FILE=/tmp/`basename $0`.$$ # # Loop through...

I've added these all to the parameter and default files: ``` [ansible@localhost templates]$ ./crosscheck_parameters.sh ================================================================================ postgresql.conf-9.1.orig postgresql.conf-9.1.j2 All parameters exist in both files -------------------------------------------------------------------------------- postgresql.conf-9.1.defaults postgresql.conf-9.1.j2 Missing silent_mode in ../defaults/main.yml...