I am considering using postgis/postgresql to host my published GIS data. Note I am not using ArcSDE / postgres database, which requires a different license than what I have. The current way that I know how to update the data from a production file geodatabase to the published postgis database is: 1) export the layer to a shapefile 2) use pgAdmin which has a tool to upload shapefiles into postgis. I would like to instead use model builder which hopefully will make it easier to upload data into postgis.
1) Is there a way to use model builder to load data directly to postgis? 2) Are there any concerns with locks, if so how can I get around them?