RHEL9 - Postgresql 17 Support

[Wild1145]

I'm currently trying to update some ansible playbooks which use this role to install Postgresql and have a requirement to be able to install Postgresql version 17.

From what I can see on the Postgres website it looks like on RHEL 9 Postgres 17 is not included in any of the out of the box repositories and you need to add their repo specifically to then be able to install it. I can't currently see an option within this role to install that repository onto the host system and then pull any version of Postgres that is supported through that repository.

Would it be possible to add this functionality so you are not limited to the versions of Postgres that ship with the OS (Or alternatively could you point me in the direction of a variable I've missed if I've missed a setting somewhere to trigger this!).

Thank you.

[sidneygijzen]

Assuming you're looking for support of the pgdg repo's, please see #73. I understand from the comments on that PR that support for pgdg is not planned for this role. I am currently using aforementioned PR to patch this role to be able to install Postgres versions which do not ship with the OS.

[Wild1145]

That's what I was looking for thank you.

I have been able to work around the problem by adding in the repo for Postgres 17 and adding the relevant GPG Keys and then running this role, it does require a few changes to the default config paths but they're already set as variables so was easy enough to get this role to work.

[sidneygijzen]

You're welcome.

Thanks for the info on the workaround you're using.

[github-actions[bot]]

This issue has been marked 'stale' due to lack of recent activity. If there is no further activity, the issue will be closed in another 30 days. Thank you for your contribution!

Please read this blog post to see the reasons why I mark issues as stale.