<html>
<head>
<meta content="text/html; charset=windows-1252"
http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
Hi John,<br>
<br>
I don't know what you mean by "cloudify" Postgis? But if you want
more flexibility with Postgis connections I can suggest that you
make your connection to a service definition and not to a
host/database directly.<br>
<br>
That way you can just change your service definition file and change
to a different server/db in case you migrate your server or you want
to switch between dev version/productive version. Or you can switch
between localhost on your laptop and your company's LAN Postgis
server. See
<a class="moz-txt-link-freetext" href="http://www.postgresql.org/docs/current/static/libpq-pgservice.html">http://www.postgresql.org/docs/current/static/libpq-pgservice.html</a><br>
<br>
Here is one example of a service definition:<br>
<br>
<title>Konsole output</title>
<div>
<span style="font-family:monospace"><span
style="color:#000000;background-color:#18b2b2;">[</span><span
style="color:#000000;background-color:#ffffff;">pg_uster</span><span
style="color:#000000;background-color:#18b2b2;">]</span><span
style="color:#000000;background-color:#ffffff;">
</span><br>
host=localhost
<br>
port=5432
<br>
dbname=uster<br>
</span></div>
<meta http-equiv="Content-Type" content="text/html;
charset=windows-1252">
<br>
Then you connect to service "pg_uster" and not directly to a
host/port/db combination. I<br>
<br>
In order for not having to type passwords I can also recommend to
use a .pgpass file.<br>
see <a class="moz-txt-link-freetext" href="http://www.postgresql.org/docs/current/static/libpq-pgpass.html">http://www.postgresql.org/docs/current/static/libpq-pgpass.html</a><br>
<br>
Andreas<br>
<br>
<div class="moz-cite-prefix">On 02.09.2015 03:59, John Harrop wrote:<br>
</div>
<blockquote
cite="mid:42855D2A-FA10-465F-A8C5-537145959E0B@gmail.com"
type="cite">
<meta http-equiv="content-type" content="text/html;
charset=windows-1252">
<div>Any suggestions on how to "cloudify" PostGIS? I would like
to use it as well and shared across more than the local
network. </div>
<div><br>
</div>
<div>Cheers, </div>
<div><br>
</div>
<div>John<br>
<br>
Sent from my iPhone</div>
<div><br>
On Sep 1, 2015, at 9:38 AM, didier peeters <<a
moz-do-not-send="true" href="mailto:dpeeter1@ulb.ac.be"><a class="moz-txt-link-abbreviated" href="mailto:dpeeter1@ulb.ac.be">dpeeter1@ulb.ac.be</a></a>>
wrote:<br>
<br>
</div>
<blockquote type="cite">
<div>
<meta http-equiv="Content-Type" content="text/html;
charset=windows-1252">
<div class="">Arni,</div>
<div class=""><br class="">
</div>
<div class="">Postgis is certainly an excellent option. </div>
<div class="">Regarding the data sources, currently QGis
cannot use relative paths to files or photos (at least) but
to svg's in styling (and maybe other, I don’t have an
exhaustive list). One option to bypass the files issue would
be to use a web server and store URL instead of internal
paths. For instance you could have a web server, and
whenever a file (or photo) is added generate with a
Postgresql trigger the corresponding url in another
attribute, making the file available to all the users,
either through a form or through an action. </div>
<div class=""><br class="">
</div>
<div class="">Didier</div>
<div class=""><br class="">
</div>
<br class="">
<div>
<blockquote type="cite" class="">
<div class="">Le 1 sept. 2015 à 17:45, Árni Geirsson <<a
moz-do-not-send="true" href="mailto:arni@alta.is"
class=""><a class="moz-txt-link-abbreviated" href="mailto:arni@alta.is">arni@alta.is</a></a>> a écrit :</div>
<br class="Apple-interchange-newline">
<div class="">
<div dir="ltr" class="">Thanks Jim
<div class="">Your answer encourages me to try the
PostGIS option - it obviously has some other useful
advantages. But your reply also made me realize that
the problem is really that much of the data I have
is on another network share - hence the problem with
the paths. I should simply move the data so that
everything is on the same share and and then,
relative paths will solve the problem.</div>
<div class="">Again, thank you for a very helpful
answer.</div>
<div class=""><br class="">
</div>
<div class="">Arni</div>
</div>
<div class="gmail_extra"><br class="" clear="all">
<div class="">
<div class="gmail_signature">
<div class=""><br class="">
</div>
<font class="" color="#666666">Árni Geirsson<br
class="">
<span style="font-size:x-small" class=""><font
class="" color="#666666"><b class="">Alta
ehf</b> // +354 582 5000 // +354 897 9549</font></span></font>
<div class=""><font class="" color="#666666"><span
style="font-size:x-small" class=""><a
moz-do-not-send="true"
href="http://www.alta.is/" target="_blank"
class=""><a class="moz-txt-link-abbreviated" href="http://www.alta.is">www.alta.is</a></a> // </span><span
style="font-size:x-small" class=""><a
moz-do-not-send="true"
href="http://twitter.com/alta_ehf"
target="_blank" class="">Alta á Twitter</a>
// <a moz-do-not-send="true"
href="http://www.facebook.com/pages/Alta/161795813838691?v=wall"
target="_blank" class="">Alta á Facebook</a></span></font><br
class="">
</div>
</div>
</div>
<br class="">
<div class="gmail_quote">On Tue, Sep 1, 2015 at 3:26
PM, James Keener <span dir="ltr" class=""><<a
moz-do-not-send="true"
href="mailto:jim@jimkeener.com" target="_blank"
class=""><a class="moz-txt-link-abbreviated" href="mailto:jim@jimkeener.com">jim@jimkeener.com</a></a>></span> wrote:<br
class="">
<blockquote class="gmail_quote" style="margin:0 0 0
.8ex;border-left:1px #ccc solid;padding-left:1ex">
<div class="">Re: postgresql in my experience it's
neither cumbersome nor slow. Feel free to email
me for help if you would like to explore that
route.<br class="">
<br class="">
Are the paths in you qgs file relative or
absolute? If their relative, is the issue that
the path separator is different? If that is the
issue, I would file a bug report. (If they are
absolute, try saving them with relative paths.)<br
class="">
<br class="">
Jim<br class="">
<br class="">
<div class="gmail_quote">
<div class="">
<div class="h5">On September 1, 2015
11:12:10 AM EDT, "Árni Geirsson" <<a
moz-do-not-send="true"
href="mailto:arni@alta.is"
target="_blank" class=""><a class="moz-txt-link-abbreviated" href="mailto:arni@alta.is">arni@alta.is</a></a>>
wrote:</div>
</div>
<blockquote class="gmail_quote"
style="margin:0pt 0pt 0pt
0.8ex;border-left:1px solid
rgb(204,204,204);padding-left:1ex">
<div class="">
<div class="h5">
<div dir="ltr" class="">Hi
<div class="">I am adding a Mac to a
local network of PCs. The Mac user
uses QGIS (as well as the PCs) and
accesses data on a shared drive. Now
the problem comes up that data
sources have different paths to the
shared drive in each operating
system, making cooperation
difficult. On the other hand, since
the .qgs file is easy to edit, some
simple solution might map the paths
automatically on open and back on
save, to compensate for these
differences. And maybe there is some
other solution out there. </div>
<div class="">I realize that having
all shared data in PostGIS might be
one way to solve this but I suspect
that it might be both slower and a
little more cumbersome.</div>
<div class="">All thoughts and
suggestions are highly appreciated.</div>
<div class="">
<div class="">
<div class="">
<div class=""><br class="">
</div>
<font class="" color="#666666">Árni
Geirsson<br class="">
<br class="">
</font></div>
</div>
</div>
</div>
<div style="margin-top: 2.5em;
margin-bottom: 1em;
border-bottom-width: 1px;
border-bottom-style: solid;
border-bottom-color: rgb(0, 0, 0);"
class=""><br
class="webkit-block-placeholder">
</div>
</div>
</div>
<pre class=""><hr class="">
Qgis-user mailing list
<a moz-do-not-send="true" href="mailto:Qgis-user@lists.osgeo.org" target="_blank" class="">Qgis-user@lists.osgeo.org</a>
<a moz-do-not-send="true" href="http://lists.osgeo.org/mailman/listinfo/qgis-user" target="_blank" class="">http://lists.osgeo.org/mailman/listinfo/qgis-user</a></pre></blockquote></div><span class="HOEnZb"><font class="" color="#888888">
--
Sent from my Android device with K-9 Mail. Please excuse my brevity.</font></span></div></blockquote></div>
</div>
_______________________________________________
Qgis-user mailing list
<a moz-do-not-send="true" href="mailto:Qgis-user@lists.osgeo.org" class="">Qgis-user@lists.osgeo.org</a>
<a moz-do-not-send="true" href="http://lists.osgeo.org/mailman/listinfo/qgis-user">http://lists.osgeo.org/mailman/listinfo/qgis-user</a></div></blockquote></div>
</div></blockquote><blockquote type="cite"><div><span>_______________________________________________</span>
<span>Qgis-user mailing list</span>
<span><a moz-do-not-send="true" href="mailto:Qgis-user@lists.osgeo.org">Qgis-user@lists.osgeo.org</a></span>
<span><a moz-do-not-send="true" href="http://lists.osgeo.org/mailman/listinfo/qgis-user">http://lists.osgeo.org/mailman/listinfo/qgis-user</a></span></div></blockquote>
<fieldset class="mimeAttachmentHeader"></fieldset>
<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>
<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>
</body></html>