I have enabled postgis extension already and have imported 3 shapefiles through the qgis db manager. Problem is that now I still have 2 large files to import and leaving qgis importing the entire night was not able to do finish the import. This is why I would need ogr2ogr to work
When I try to use the following command
ogr2ogr -f PostgreSQL PG:"dbname='postgres' host='hostnamehere' port='5432' user='user' password=passwordhere" folders/file.shp -nlt MULTIPOLYGON
I simply get the following error:
Unable to open datasource `folders/file.shp' with the following drivers.
The file opens just fine on QGIS. Is my ogr2ogr command wrong?
Alternatively I also tried psql as I've seen here on this website using:
psql -h host=hosthere gis postgres -p 5432
But got met with this error
psql: could not translate host name "host=host.rds.amazonaws.com" to address: nodename nor servname provided, or not known
I then tried using dbeaver to import a file from a csv but I keep getting java.lang.NullPointerException and it just doesnt appear to match the fields, yet the file still opens fine on Excel
Is my Ogr2ogr wrong or is there a different thing I can try?