[Qgis-user] Metadata and databases; thanks RE: Backing up GIS Data

[Falk Huettmann]

Hi there,



Thanks,

I am fully with the notion of back-ups and data management, specifically,

metadata (a topic we pushed for over a decade but it has no good uptake,
still).



While some QGIS users might still try to learn Danish terms (a peculiar
language that is just spoken by some

~60mio people or so; sorry to say it), I sincerely hope the next version of
QGIS is in Chinese instead, and thus serves many billions. OpenSource is
well served then. The EU-centrism ain’t so funny, in GIS, R and beyond.



Equally serious, I do not believe that QGIS, overall, is so powerful on the
actual database side of things.

If possible here, I would highly appreciate to learn specific and powerful
links on HOW QGIS relates and works with databases, and what the underlying
concept, idea and visions are ?

Thanks in advance for that.



In addition, in case you know of latest ISO metadata (XML I assume; I see
virus filter issues in that) approaches to QGIS and tabs and packages I
would die for learning about it for sure, too.

It’s so much needed.



Envision Chinese GIS data all available and documented with metadata open
source for everybody to use…

why not ?



Thanks in advance; very best regards

   Falk Huettmann



Falk Huettmann PhD, Associate Professor

-EWHALE lab- Biology and Wildlife Dept., Institute of Arctic Biology

419 IRVING I, University of Alaska Fairbanks AK 99775-7000 USA

Email fhuettmann at alaska.edu  Phone 907 474 7882 Fax 907 474 6716





*From:* Qgis-user [mailto:qgis-user-bounces at lists.osgeo.org] *On Behalf Of *Bo
Victor Thomsen
*Sent:* Thursday, July 14, 2016 9:04 PM
*To:* qgis-user at lists.osgeo.org
*Subject:* Re: [Qgis-user] Backing up GIS Data



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/20160714/e56a8c15/attachment.html>