<html>
<head>
<meta content="text/html; charset=utf-8" http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
<div class="moz-cite-prefix">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
cite="mid:CANfsH31rjor8bLboC-wHaRqiV7DPL09+XJeipiWjsD0PELQrPw@mail.gmail.com"
type="cite">
<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 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>
<p><br>
</p>
</body>
</html>