As an old GIS database dog -
* It's a wise and smart decision to use Postgres/PostGis for storing
and using spatial data.
* As for backup: Do *exactly* as Jeff writes :-). "Point in time"
backups are nice, but not the best backup solution for Postgres
databases. Jeff's solution is.
Regards
Bo Victor Thomsen
AestasGIS
Denmark
Den 14/07/16 kl. 21:26 skrev Jeff McKenna:
Hi Tyler,
This is a good question, and an important one, and don't feel bad
about posting it here - likely we can all learn from this discussion,
as it definitely involves the whole QGIS community.
I have quite a lot of experience backing up databases, especially
PostgreSQL/PostGIS databases. I can tell you that it is for sure
important to run "pg_dump" as a daily backup (in addition to your
whole server image/backup) - that pg_dump has saved me and my clients
hundreds of times, and it is very portable and easy to access (as
opposed to your whole image/machine backup). One very important point
(that's I've learned from experience) when using pg_dump is to
*always* use the custom binary/compressed output format (the
"--format=c" commandline switch for pg_dump). I've had terrible times
with the other output format types, especially when restoring a
database from a Windows server to a Linux server etc (with hardcoded
paths inside the backup). I live by that format, swear by it, from
experience, moving so many client databases from one machine to another.
Another mailing list to keep in mind is the PostGIS mailing list,
where these backup topics also pop up from time to time - and
discussions are more geo-related, so are very helpful, than just the
generic PostgreSQL mailing list.
So, definitely implement an additional backup process using pg_dump
(you can experiment restoring it through the "pg_restore" command),
you won't regret the effort spent.
Happy QGIS-ing,
-jeff
_______________________________________________
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: http://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user