I have been struggling with Importing a feature service into a PostgreSQL connection until I came across this article - https://pro.arcgis.com/en/pro-app/latest/help/data/databases/add-the-st-geometry-type-to-a-postgresq... which talks about adding the ST_Geometry library to the PostgreSQL installation path.
Unfortunately, the available ST_Geometry library only supports up to Version 15 of PostgreSQL. I currently have PostgreSQL 16 installed and I cannot seem to find a way around this.
Anyone to help out on this? Downgrading from Version 16 to 15 is the only last option at this moment.