Missing dependencies on ubuntu 24.04 for libpq-dev and postgresql-server-dev-17

Hi,

I wanted to create a development environment on Ubuntu 22.04 using several packages from pgdg repositories. I want to share the error messages with you here in the hopes that this is correct venue.

Postgresql-server-dev-17 depends on libpq-dev and libpq-dev has two broken dependencies:
- libldap only has versions 2.6.X on Ubuntu 24.04 and is not compatible with libldap-2.4-2 dependency requirement.
- libssl1.1 is not available on Ubuntu 24.04. A quick search shows that it is not available in any Ubuntu version, and Debian 11 is the only Debian version that has that package available in official packaging repositories.

sh$ sudo apt install libpq-dev=17.5-1.pgdg110+1
...
The following packages have unmet dependencies:
libpq5 : Depends: libldap-2.4-2 (>= 2.4.7) but it is not installable
Depends: libssl1.1 (>= 1.1.1) but it is not installable
E: Unable to correct problems, you have held broken packages.

Thanks for the help,
Hanefi