[postgis-users] PostGIS over distributed worksites
rox at tara-lu.com
Sun Mar 6 20:50:30 PST 2016
I'm not sure what portions / parts of your db are shared or vary on a
per seat basis, and this isn't my normal area of mucking... but I'll
throw some ideas out and let other people improve them :)
What if you set up a master database - perhaps AWS. Set each
distributed seat to replicate down. Updates are pushed to the master by
someone, and each distributed seat is auto-updated.
What won't work with a pure replicated server instance.. is local
changes, if you have them.... and so again - not my area of playing, but
what about two local databases? One local for changes, and a second
that is pure replication.
That complicates your connection configuration and potentially your tool
Otherwise, as I understand it, barman can create a backup of one
instance and restore the full working database to another site - so you
could create a shared barman replication service where individual seats
could recover a master DB when updates are required.
just some thoughts to stir the discussion.
On 3/6/2016 7:21 PM, Lee Hachadoorian wrote:
> I usually use PostGIS in a localhost or a LAN setting, where I or my
> workgroup can all be connected to the database all the time.
> I recently set up a QGIS project using SpatiaLite with Dropbox
> syncing, because project participants were at multiple worksites.
> However, rendering--particularly rendering of QueryLayers--is quite
> slow, and QGIS often crashes. Testing shows that QGIS is much more
> responsive with PostGIS as the back end, and although it's difficult
> to prove a negative, it seems that QGIS crashes don't happen (or at
> least clearly happen less often). So I would like to transition the
> project to PostGIS.
> I am asking for your recommendations or experiences with setting this
> up in a way that will be fairly easy to show users who are technically
> savvy but new to database management. Some details:
> 1. Small workgroup (5 or so).
> 2. Spatial layers are big releases from city government (parcels,
> streets, infrastructure) which are updated at most a couple of times a
> year, often less frequently. Each spatial layer is updated on a
> different schedule by different agencies.
> 3. Data releases are in shapefile (blecch!).
> 4. Users do meet in person with some regularity.
> As a suggestion, I am considering just having everyone set up
> localhost installs of PostGIS. When there is a new data release, one
> person could load and clean the data, then dump the table, copy the
> dump to Dropbox, and other users could load the new table in their
> localhost database.
> Obviously this solution is not scalable--more users or more frequent
> updates would make it quite tedious--but it may work for this use
> case. I am open to criticisms and suggestions.
More information about the postgis-users