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 re
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 dow
Distributing periodic updates via dropbox or rsync is not a bad approach.
Postgres will do cascading replication
http://www.postgresql.org/docs/current/static/warm-standby.html#CASCADING-REPLICATION
( since 9.2 )
So that is one possible way to distribute that data.
Be aware that using replicatio
Subject: Re: [postgis-users] PostGIS over distributed worksites
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
At the moment it looks like our use case is data is updated from
canonical sources (gov't agencies), and users are just using for
analysis and visualization, not making changes to original data. So
read-only/one-way sync will work for us.
Don't know about AWS. Data sets are single-digit GB. Mo
You set can a Master up anywhere that your remote desktops can reach it.
One other datum of possible value to you... - barman can be used to
backup/restore individual tables as well... (as I understand it). Using
a full backup might simplify configuring a new install. Using table
restorations
-users] PostGIS over distributed worksites
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 - pe
4:09 PM
To: postgis-users@lists.osgeo.org
Subject: Re: [postgis-users] PostGIS over distributed worksites
Robert,
Meaning that you also have to maintain a Mapserver web server with
static IP? If so, it is probably not the right solution for this
project, but worth keeping in mind. Thanks for the
