Method of extending PostgreSQL service unit configuration is deprecated

[p-j-smith]

Currently, the service configuration is done by writing the values to override to the file "/etc/systemd/system/{{ postgresql_service_name }}.service":

ansible-role-postgresql/tasks/main.yml

Lines 44 to 51 in 78e404b

	- name: Set custom postgresql service configuration
	ansible.builtin.template:
	src: postgresql.service.j2
	dest: "{{ postgresql_service.filename }}"
	owner: "root"
	group: "root"
	mode: 0644
	register: postgresql_custom_service_config

However, the template file uses the deprecated keyword include to include the default configuration:

ansible-role-postgresql/templates/postgresql.service.j2

Line 1 in 78e404b

.include /lib/systemd/system/{{ postgresql_service_name }}.service

Either:

• the entire configuration should be added to "/etc/systemd/system/{{ postgresql_service_name }}.service", as described here
• or, the default configuration can be extended as described here

Note, this causes an error on Red Hat 9 as support for the include keyword has been removed.