Skip to content

issues Search Results · repo:UCL-MIRSG/ansible-role-postgresql language:Jinja

Filter by

9 results
 (73 ms)

9 results

inUCL-MIRSG/ansible-role-postgresql (press backspace or delete to remove)

In https://github.com/UCL-MIRSG/ansible-role-postgresql/pull/13 the way service definitions are extended was changed so that this role works on RHEL 9. Essentially the configuration has moved from: /etc/systemd/system/{{ ...
  • p-j-smith
  • 1
  • Opened 
    on Aug 21, 2023
  • #15

As suggested by @drmatthews in https://github.com/UCL-MIRSG/ansible-role-postgresql/pull/13#pullrequestreview-1511394078, we should use the renovate bot to track pre-commit hook versions
  • p-j-smith
  • 1
  • Opened 
    on Jul 3, 2023
  • #14

XNAT supports PostgreSQL 10 - 14. In our pg_hba.conf template, we set clientcert=1 if using SSL. However, this is deprecated in PosgreSQL 14 and should be either clientcert=verify-ca (equivalent to clientcert=1) ...
  • p-j-smith
  • 1
  • Opened 
    on Jul 3, 2023
  • #11

Currently, the service configuration is done by writing the values to override to the file /etc/systemd/system/{{ postgresql_service_name }}.service: https://github.com/UCL-MIRSG/ansible-role-postgresql/blob/78e404b1bcd74ce5dba3948e24ef49a1c7cebc1e/tasks/main.yml#L44-L51 ...
  • p-j-smith
  • Opened 
    on Jul 3, 2023
  • #10

The default for listen_addresses needs to be removed from postgresql.conf.j2. The default for subnet_mask needs to be removed from pg_hba.conf.j2.
bug
  • drmatthews
  • Opened 
    on Apr 28, 2023
  • #8

The task Ensure there is a symbolic link from postgresql data_directory to storage will only work if storage_directory is a different directory to data_directory, as would happen if the data is being stored ...
bug
  • drmatthews
  • Opened 
    on Mar 1, 2023
  • #6

The template postgresql.conf.j2 should include a variable to allow flexibility in setting listen_addresses. This should fall back to localhost, xnat_db.host if that variable is not set.
enhancement
  • drmatthews
  • 1
  • Opened 
    on Feb 28, 2023
  • #4

The default subnet mask is 255.255.255.255 which means that a single IP address is allowed to access the database. To make this more generic a variable should be introduced to allow setting the subnet ...
enhancement
  • drmatthews
  • Opened 
    on Feb 28, 2023
  • #3

There are some differences between the XnatInstaller and and OmeroInstaller postgresql roles. I ll list them here and, where I have an idea of how to, suggest how to handle these differences in this standalone ...
  • p-j-smith
  • 2
  • Opened 
    on Jan 25, 2023
  • #1
Issue origami icon

Learn how you can use GitHub Issues to plan and track your work.

Save views for sprints, backlogs, teams, or releases. Rank, sort, and filter issues to suit the occasion. The possibilities are endless.Learn more about GitHub Issues
ProTip! 
Restrict your search to the title by using the in:title qualifier.
Issue origami icon

Learn how you can use GitHub Issues to plan and track your work.

Save views for sprints, backlogs, teams, or releases. Rank, sort, and filter issues to suit the occasion. The possibilities are endless.Learn more about GitHub Issues
ProTip! 
Restrict your search to the title by using the in:title qualifier.
Issue search results · GitHub