<html style="direction: ltr;">
<head>
<meta content="text/html; charset=utf-8" http-equiv="Content-Type">
<style type="text/css">body p { margin-bottom: 0cm; margin-top: 0pt; } </style>
</head>
<body style="direction: ltr;" bidimailui-charset-is-forced="true"
smarttemplateinserted="true" text="#000000" bgcolor="#FFFFFF">
<div id="smartTemplate4-template">
<div id="my_message">Hi
<br>
</div>
</div>
<br>
<br>
<div id="smartTemplate4-quoteHeader">------ Original Message ------
Subject: Re: [Qgis-user] Backing up GIS Data
Date: Fri, 15 Jul 2016 07:04:20 +0200
To: Qgis-user
From: Bo Victor Thomsen</div>
<blockquote
cite="mid:46e99e20-8b2b-44ef-1a2a-c905cac25153@gmail.com"
type="cite">
<meta content="text/html; charset=utf-8" http-equiv="Content-Type">
<p>As an old GIS database dog -</p>
<ul>
<li>It's a wise and smart decision to use Postgres/PostGis for
storing and using spatial data.<br>
</li>
<li>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. <br>
</li>
</ul>
<br>
Regards<br>
<br>
Bo Victor Thomsen<br>
AestasGIS<br>
Denmark<br>
<br>
<p><br>
</p>
<p><br>
</p>
<p><br>
</p>
<br>
<div class="moz-cite-prefix">Den 14/07/16 kl. 21:26 skrev Jeff
McKenna:<br>
</div>
<blockquote
cite="mid:cc0bcf05-924e-8f8f-9a4c-21de230d634b@gatewaygeomatics.com"
type="cite">Hi Tyler, <br>
<br>
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.
<br>
<br>
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 </blockquote>
</blockquote>
<br>
I have always used the default "plain" format for pg_dump backups.
When time comes to migrate data to a new installation, it allows me
to edit the SQL backup file: restore only some of the tables, change
owners, schema names, even change the database name. This is just a
minor convenience. Am I making a mistake? Should I move to the
binary format to insure reliability? <br>
<br>
Thanks<br>
<blockquote
cite="mid:46e99e20-8b2b-44ef-1a2a-c905cac25153@gmail.com"
type="cite">
<blockquote
cite="mid:cc0bcf05-924e-8f8f-9a4c-21de230d634b@gatewaygeomatics.com"
type="cite">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. <br>
<br>
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. <br>
<br>
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. <br>
<br>
Happy QGIS-ing, <br>
<br>
-jeff <br>
<br>
<br>
</blockquote>
<br>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">_______________________________________________
Qgis-user mailing list
<a class="moz-txt-link-abbreviated" href="mailto:Qgis-user@lists.osgeo.org">Qgis-user@lists.osgeo.org</a>
List info: <a class="moz-txt-link-freetext" href="http://lists.osgeo.org/mailman/listinfo/qgis-user">http://lists.osgeo.org/mailman/listinfo/qgis-user</a>
Unsubscribe: <a class="moz-txt-link-freetext" href="http://lists.osgeo.org/mailman/listinfo/qgis-user">http://lists.osgeo.org/mailman/listinfo/qgis-user</a></pre>
</blockquote>
<div class="moz-signature">
<div dir="LTR">
Micha Silver<br>
Arava Drainage Authority<br>
+972-523-665918
</div>
</div>
</body>
</html>