[Qgis-user] Fwd: Re: Backing up GIS Data

[ThomasD]

Well - PG is very powerful and has therefore lots of options which might 
affect behaviour in future e.g. after system changes. All I mentioned is 
really not such a big deal. But with databases its often better to think 
of how setting up your individual system before starting productive work.

That includes in my opinion how you want to work on when a certain type 
of system crash occurs (server not available, client hardware blown 
up....), see for example 
https://wiki.postgresql.org/wiki/Category:Backup. And PG-backup gives 
you much more security in that case as a plain server backup. You can do 
that automatically (see link above).
For general information I would try out the Postgres-documentations 
under https://www.postgresql.org/docs/. There you might find a lot 
about  backup, setting up variables etc.

More Tutorials can be found under 
https://wiki.postgresql.org/wiki/PostgreSQL_Tutorials.

Concerning PostGis, I learned a lot from "PostGIs in Action" by R.O.Obe 
and L.S.Hsu (Manning Publications, Stanford).

Thomas

> This is all really good but I was hoping I could just install it on 
> our server and go because I am not a database administrator; just a 
> GIS Tech. Where can I go to learn about database backups methods and 
> procedures, best practices and that sort of thing? Any good, free 
> online postgre courses? book suggestions? I already have PostGIS in 
> Action.
> Thanks all;
> Tyler
>
> On Fri, Jul 15, 2016 at 4:47 AM, ThomasD <ThomasD.mailinglists at gmx.de 
> <mailto:ThomasD.mailinglists at gmx.de>> wrote:
>
>     Hi Tyler
>
>     I have only little experience with PG backups - but I can
>     emphasize from that little that it is very helpful to use pg_dump
>     regulary. Better don't rely on backups of your datadirectory.
>     Although have in mind, that after a crash you might use different
>     computers. It might help, when these are tested for successful
>     restore/rollback in advance.
>
>     Concerning later server versions you might refer to the PG-Groups
>     an mailing lists for recent issues. Until now I have restored my
>     database (private for birding data) twice with diferent versions
>     aof postgres and it worked just fine. But I have functions only
>     written in PL/PGsql. I could imagine that you might run into
>     difficulties, when using different languages in different server
>     versions like Python2 and Python3. Different Path and Variable
>     settings (e.g. locals) might in that case also be an issue.
>
>     Thomas
>
>>     Hi All;
>>     I am thinking about getting IT to install PostgreSQL on our
>>     server and start moving our GIS Data over to the post database.
>>     My concern is backup; we currently backup the whole server onto,
>>     what are called "tapes" but I am sure they are not cassettes or
>>     the like, anyway twice a day the whole server is copied so we can
>>     go back to previous versions of a file or folder to; roll back,
>>     restore, or recover. With this in place do I need to setup a
>>     separate backup or replication service on the postgre database?
>>     Could I just "roll back" using a later server version?
>>     Well.... I guess this is more of a postgre question and not so
>>     much a QGIS one; but I am going to put this out there anyway and
>>     if no one can answer I will find another spot.
>>     Thanks
>>     Tyler
>>
>>
>>     _______________________________________________
>>     Qgis-user mailing list
>>     Qgis-user at lists.osgeo.org <mailto:Qgis-user at lists.osgeo.org>
>>     List info:http://lists.osgeo.org/mailman/listinfo/qgis-user
>>     Unsubscribe:http://lists.osgeo.org/mailman/listinfo/qgis-user
>
>
>

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