[BUG] Install PostgreSQL Foreign Data Wrapper for Oracle (oracle_fdw) task fails in version 1.0.0

[ledepedro]

Description

The Install PostgreSQL Foreign Data Wrapper for Oracle (oracle_fdw) task fails in version 1.0.0 of this feature if the path is found to be permission denied when checking to see if it is installed.

The 'Include extension to install' task does not ensure that the tasks to be included are found in the role directory. It is modified to ensure that task files are included in the role path.

Changing DNS to IP in listen_addresses and connect_addres in patroni.yml.

Add newer extensions postgres: pgvector, pgvectorscale.

Steps to Reproduce

Run the role with oracle_fdw in extensions_install on a host where there is path without permission to find.

Expected behavior:
The role installs oracle_fdw extension.

Actual behavior:
The role ends in an error due to find path permission denied.

Reproduces how often:
Every time the role is executed on a system where find path permission denied.

Environment

• The release version/s you are using: 1.0.0
• OS: Debian12
• Ansible Version: 7.6.0
• Python Version: 3.10.13
• Others: