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.mailingli...@gmx.de <mailto:thomasd.mailingli...@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@lists.osgeo.org <mailto:Qgis-user@lists.osgeo.org>
    List info:http://lists.osgeo.org/mailman/listinfo/qgis-user
    Unsubscribe:http://lists.osgeo.org/mailman/listinfo/qgis-user




_______________________________________________
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

Reply via email to