Welcome to the Microsoft Q&A Platform. Thank you for reaching out & I hope you are doing well.
I understand that you have AVD (formerly WVD) machines from which you would like to access another VM on Port 5432
Per your verbatim,
- The VM cannot have a NSG that allows incoming connections on Port 5432 with "Source" as Any
- The AVD machine cannot be attached a Public IP (Fixed IP)
In this case,
- You have to connect privately to the VM on Port 5432
- The best way I can think of is to Peer the AVD Vnet and the VM's VNET
- Once done, traffic from AVD Vnet can access resources in the VM's VNET
- See : Network topology and connectivity for Azure Virtual Desktop
Hope this helps.
Cheers
Kapil