<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=utf-8">
</head>
<body bgcolor="#FFFFFF" text="#000000">
<br>
<div class="moz-forward-container">
<meta content="text/html; charset=utf-8" http-equiv="Content-Type">
<div class="moz-cite-prefix">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. <br>
<br>
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 <a
moz-do-not-send="true" class="moz-txt-link-freetext"
href="https://wiki.postgresql.org/wiki/Category:Backup">https://wiki.postgresql.org/wiki/Category:Backup</a>.
And PG-backup gives you much more security in that case as a
plain server backup. You can do that automatically (see link
above).<br>
For general information I would try out the
Postgres-documentations under <a moz-do-not-send="true"
class="moz-txt-link-freetext"
href="https://www.postgresql.org/docs/">https://www.postgresql.org/docs/</a>.
There you might find a lot about backup, setting up variables
etc.<br>
<br>
More Tutorials can be found under <a moz-do-not-send="true"
class="moz-txt-link-freetext"
href="https://wiki.postgresql.org/wiki/PostgreSQL_Tutorials">https://wiki.postgresql.org/wiki/PostgreSQL_Tutorials</a>.<br>
<br>
Concerning PostGis, I learned a lot from "PostGIs in Action" by
R.O.Obe and L.S.Hsu (Manning Publications, Stanford). <br>
<br>
Thomas<br>
<br>
</div>
<blockquote
cite="mid:CANfsH32B_seQcrUUJKrQbUs-7C7UAs_b5hcxToo+=N0iW_T+sA@mail.gmail.com"
type="cite">
<div dir="ltr">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.
<div>Thanks all;</div>
<div>Tyler</div>
</div>
<div class="gmail_extra"><br>
<div class="gmail_quote">On Fri, Jul 15, 2016 at 4:47 AM,
ThomasD <span dir="ltr"><<a moz-do-not-send="true"
href="mailto:ThomasD.mailinglists@gmx.de"
target="_blank">ThomasD.mailinglists@gmx.de</a>></span>
wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0
.8ex;border-left:1px #ccc solid;padding-left:1ex">
<div bgcolor="#FFFFFF" text="#000000">
<div>Hi Tyler<br>
<br>
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. <br>
<br>
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.<br>
<br>
Thomas<br>
<br>
</div>
<blockquote type="cite">
<div>
<div class="h5">
<div dir="ltr">Hi All;
<div>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?</div>
<div>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.</div>
<div>Thanks</div>
<div>Tyler</div>
</div>
<br>
<fieldset></fieldset>
<br>
</div>
</div>
<span class="">
<pre>_______________________________________________
Qgis-user mailing list
<a moz-do-not-send="true" href="mailto:Qgis-user@lists.osgeo.org" target="_blank">Qgis-user@lists.osgeo.org</a>
List info: <a moz-do-not-send="true" href="http://lists.osgeo.org/mailman/listinfo/qgis-user" target="_blank">http://lists.osgeo.org/mailman/listinfo/qgis-user</a>
Unsubscribe: <a moz-do-not-send="true" href="http://lists.osgeo.org/mailman/listinfo/qgis-user" target="_blank">http://lists.osgeo.org/mailman/listinfo/qgis-user</a></pre>
</span></blockquote>
<p><br>
</p>
</div>
</blockquote>
</div>
<br>
</div>
</blockquote>
<p><br>
</p>
</div>
</body>
</html>