I recommend using QGIS PostGIS Manager plugin which is a GUI for shp2pgsql which allows you to upload Shapefiles to a remote database. ![enter image description here][1] [1]: https://i.sstatic.net/PRLRA.png