CI: integration testing against all supported Postgres versions

[Andersson007]

SUMMARY

• Currently we tests using AZP and several distros with default Postgres versions available for each distro. See .azure-pipelines/azure-pipelines.yml file.
• Postgres 14 has been recently released with some breaking changes and we don't have testing against it yet.

Solution:

• Moving to GitHub actions
• Testing using one distro against all supported Postgres versions + maybe 9.2
• An example is community.mysql collection, .github directory content

Temporary solution (done with Added with https://github.com/ansible-collections/community.postgresql/pull/156) can be using one of the distros (say, Ubuntu 20.04 or whatever) to install Postgres 14.

[klando]

the PR is supposed to address this issue.

[klando]

https://github.com/ansible-collections/community.postgresql/pull/166 is covering all PostgreSQL versions on ubuntu-2004

[Andersson007]

closing this to keep the tracker clean, thanks everyone!