I am new to PostGIS/PostgreSQL and have downloaded and installed to perform a spatial join which ideally takes 27 hours in ArcGIS Pro and 19 hours by ArcPy.Hoping for a faster results via PostGIS from what I read everywhere online.
I have installed both PostgreSQL and PostGIS. But I am unable to import a shapefile to the database. Basically I have a spatial table in Sql Server which I is somewhat challenging to import to pgAdmin as I cannot figure out a way to connect the database of sql server using ogr_fdw. The answer here does not help as I believe there are some restrictions in the organization end causing a failure as it only takes windows authentication.
As a workaround I converted the spatial table to a shapefile using feature to feature conversion. But now I am unable to import the shapefile to PostGIS/PostgreSQL. I am using the shp2pgsql GUI for importing and its throwing out a "Error reading shape output" as an error.
Any suggestion to have my spatial table imported to postgis or a way to get the converted shapefile imported?