<html>
<head>
<meta content="text/html; charset=windows-1252"
http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
If you are transferring your database to the same or newer version
of Postgresql then generally: yes. But take some precautions: <br>
<ul>
<li>In the original database: Don't use schema public to store
data; create another schema for that purpose. The reason for
this action is to separate all the postgis functions and view -
which resides in schema "public" - from ordenary data.</li>
<li>When you make a backup: Only backup your data schema (not
public). This means, that you won't get any version specific,
postgis related stuff into your backup.</li>
<li>When you restore the backup in another database: First create
the PostGIS extension in this database with the command "Create
extension postgis". This will create the PostGIS extension in
the new database. Secondly: restore your backup. This will
restore the data schema in the database. <br>
</li>
</ul>
If the source and target database system resides on two computers
with the same operating system and same postgres and postgis
version, the above procedure is not needed. Simply make a backup of
the source database and restore it on the target computer.<br>
<br>
Regards<br>
Bo Victor Thomsen<br>
AestasGIS<br>
Denmark<br>
<br>
<div class="moz-cite-prefix">Den 05-03-2015 kl. 16:57 skrev Andre
Joost:<br>
</div>
<blockquote cite="mid:md9usr$7ep$3@ger.gmane.org" type="cite">Am
05.03.2015 um 13:01 schrieb Rémi Cura:
<br>
<br>
<blockquote type="cite">The equivalent way, that is also the
simplest, is to dump the tables (and
<br>
related functions/triggers if necessary) into a file, then
restore the
<br>
table in the target postgis database!
<br>
</blockquote>
<br>
Does this work if the users are on different OS, like
Windows/Linux/Mac OSX, 32bit or 64bit, or maybe different
PostgreSQL/Postgis versions?
<br>
<br>
<br>
greetings,
<br>
André Joost
<br>
<br>
_______________________________________________
<br>
Qgis-user mailing list
<br>
<a class="moz-txt-link-abbreviated" href="mailto:Qgis-user@lists.osgeo.org">Qgis-user@lists.osgeo.org</a>
<br>
<a class="moz-txt-link-freetext" href="http://lists.osgeo.org/mailman/listinfo/qgis-user">http://lists.osgeo.org/mailman/listinfo/qgis-user</a>
<br>
</blockquote>
<br>
</body>
</html>