We are using PostGIS to serve our geographic data by WMTS with GeoServer, and the origin data are produced with ArcMap (using the file geodatabase format).
We use the ArcMap database connection tool to export data to the database. However all the data take up almost 20GB, it may cost 10 hours to export all of them to the database.
Now once there are some modification of the origin data, how to update the database effectively?
It is not a wise option to export them all again.