For windows, use Stack Builder which is installed together with PostGreSQL. Under Category > Spatial Extensions > select the PostGIS version for installation.
For Ubuntu, it is easier to use Docker for installation.
It is easiest to use postgisgui for uploading shapefiles.
Go to C:\Program Files\PostgreSQL\9.6\bin\postgisgui or whichever directory PostGres was installed in. Double click the application.
Open the connection button and connect to the database.
Remember to add the SRID. 3414 is the coordinate system for Singapore's SVY21.
Spatial indexing is automatically done using this tool when uploading the shapefiles to PostGIS.
ArcGIS by default does not allow editing. However, 3rd party paid extensions like gisquirrel allows this.
QGIS bby default allows for editing/deleting.
GeoServer can be connected to PostGIS & published the layers. In GeoServer, create a new store with connection to PostGIS, and select the relevant tables to publish as a WMS.
After publishing, you can go back and add new layers from the same database / store, by clicking Layer > Add a new layer.
# PostGIS version SELECT PostGIS_full_version(); # Data directory path show data_directory;