[Qgis-user] Backing up GIS Data

[Bo Victor Thomsen]

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
>
>

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20160715/ff641138/attachment.html>