<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
</head>
<body text="#000000" bgcolor="#FFFFFF">
<div class="moz-cite-prefix">Hi,<br>
<br>
Some time ago I installed PostgreSQL with the DBEntreprise
installer, but it was coming with the PgAdmin 4,witch I really
didn't appreciate (mostly because it runs really slowly in
comparison with PgAdmin3 on my machine ...).<br>
For that reason I came back to PostgreSQL 9.6.<br>
Do you know If it's now possible to have PostgreSQL 10 installed
with PgAdmin 3 (or if PgAdmin 4 has dealt with his problems of
slowness, wich many people have noticed) ? <br>
<br>
Thanks,<br>
Jean<br>
<br>
<br>
Le 11/12/2017 à 20:24, Anthony DeBarros a écrit :<br>
</div>
<blockquote type="cite"
cite="mid:CAAQFaFK0KqXB9tEyYP2LBgM6UZAZg_ipchrSQf-PN1PgKRBcLA@mail.gmail.com">
<style>body{font-family:Helvetica,Arial;font-size:13px}</style>
<div id="bloop_customfont"
style="font-family:Helvetica,Arial;font-size:13px;color:rgba(0,0,0,1.0);margin:0px;line-height:auto">Thanks,
Regina,</div>
<div id="bloop_customfont"
style="font-family:Helvetica,Arial;font-size:13px;color:rgba(0,0,0,1.0);margin:0px;line-height:auto"><br>
</div>
<div id="bloop_customfont"
style="font-family:Helvetica,Arial;font-size:13px;color:rgba(0,0,0,1.0);margin:0px;line-height:auto">Nope,
Postgres.app doesn’t include it. Haven’t successfully found an
alternative.</div>
<div id="bloop_customfont"
style="font-family:Helvetica,Arial;font-size:13px;color:rgba(0,0,0,1.0);margin:0px;line-height:auto"><br>
</div>
<div id="bloop_customfont"
style="font-family:Helvetica,Arial;font-size:13px;color:rgba(0,0,0,1.0);margin:0px;line-height:auto">Anthony</div>
<br>
<br>
<p class="airmail_on">On December 11, 2017 at 1:17:19 PM, Regina
Obe (<a href="mailto:lr@pcorp.us" moz-do-not-send="true">lr@pcorp.us</a>)
wrote:</p>
<blockquote type="cite" class="clean_bq"><span>
<div link="blue" vlink="purple" lang="EN-US">
<div>
<div class="WordSection1">
<p class="MsoNormal"><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d">Anthony,</span></p>
<p class="MsoNormal"><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d"> </span></p>
<p class="MsoNormal"><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d">Sorry
no clue about Mac. I thought perhaps Postgres.app
might have it</span></p>
<p class="MsoNormal"><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d"> </span></p>
<p class="MsoNormal"><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d"><a
href="http://postgresapp.com/documentation/gui-tools.html"
moz-do-not-send="true">http://postgresapp.com/documentation/gui-tools.html</a></span></p>
<p class="MsoNormal"><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d"> </span></p>
<p class="MsoNormal"><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d">but
don't see it listed under their Gui Client apps.
It's possible they missed listing it and they have
it.</span></p>
<p class="MsoNormal"><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d"> </span></p>
<p class="MsoNormal"><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d">I
see the PostGIS commandline tools listed under CLI
apps though</span></p>
<p class="MsoNormal"><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d"> </span></p>
<p class="MsoNormal"><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d"><a
href="http://postgresapp.com/documentation/cli-tools.html"
moz-do-not-send="true">http://postgresapp.com/documentation/cli-tools.html</a></span></p>
<p class="MsoNormal"><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d"> </span></p>
<p class="MsoNormal"><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d">Thanks,</span></p>
<p class="MsoNormal"><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d">Regina</span></p>
<p class="MsoNormal"><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d"> </span></p>
<div>
<div style="border:none;border-top:solid #e1e1e1
1.0pt;padding:3.0pt 0in 0in 0in">
<p class="MsoNormal" style="margin-left:.5in"><b><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif">From:</span></b><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif">
postgis-users [mailto:<a
href="mailto:postgis-users-bounces@lists.osgeo.org"
moz-do-not-send="true">postgis-users-bounces@lists.osgeo.org</a>]
<b>On Behalf Of </b>Anthony DeBarros<br>
<b>Sent:</b> Monday, December 11, 2017 8:41 AM<br>
<b>To:</b> PostGIS Users Discussion <<a
href="mailto:postgis-users@lists.osgeo.org"
moz-do-not-send="true">postgis-users@lists.osgeo.org</a>><br>
<b>Subject:</b> Re: [postgis-users] Given up</span></p>
</div>
</div>
<p class="MsoNormal" style="margin-left:.5in"> </p>
<div id="bloop_customfont">
<p class="MsoNormal" style="margin-left:.5in"><span
style="font-size:10.0pt;font-family:"Helvetica",sans-serif">Regina
(or anyone),</span></p>
</div>
<div id="bloop_customfont">
<p class="MsoNormal" style="margin-left:.5in"><span
style="font-size:10.0pt;font-family:"Helvetica",sans-serif"> </span></p>
</div>
<div id="bloop_customfont">
<p class="MsoNormal" style="margin-left:.5in"><span
style="font-size:10.0pt;font-family:"Helvetica",sans-serif">I
had posted a couple weeks back about not being
able to find a version of the Shapefile Loader GUI
that works under macOS High Sierra. The one I
recently downloaded from Boundless doesn’t work.
Any ideas on alternates?</span></p>
</div>
<div id="bloop_customfont">
<p class="MsoNormal" style="margin-left:.5in"><span
style="font-size:10.0pt;font-family:"Helvetica",sans-serif"> </span></p>
</div>
<div id="bloop_customfont">
<p class="MsoNormal" style="margin-left:.5in"><span
style="font-size:10.0pt;font-family:"Helvetica",sans-serif">Thanks,</span></p>
</div>
<div id="bloop_customfont">
<p class="MsoNormal" style="margin-left:.5in"><span
style="font-size:10.0pt;font-family:"Helvetica",sans-serif">Anthony</span></p>
</div>
<p class="MsoNormal" style="margin-left:.5in"><span
style="font-size:10.0pt;font-family:"Helvetica",sans-serif"> </span></p>
<p class="MsoNormal" style="margin-left:.5in"><span
style="font-size:10.0pt;font-family:"Helvetica",sans-serif"> </span></p>
<p class="airmailon" style="margin-left:.5in"><span
style="font-size:10.0pt;font-family:"Helvetica",sans-serif">On
December 11, 2017 at 8:23:31 AM, Regina Obe (<a
href="mailto:lr@pcorp.us" moz-do-not-send="true">lr@pcorp.us</a>)
wrote:</span></p>
<blockquote style="margin-top:5.0pt;margin-bottom:5.0pt">
<div>
<div>
<div>
<p class="MsoPlainText" style="margin-left:.5in"><span
style="font-size:10.0pt;font-family:"Helvetica",sans-serif">Darrel,</span></p>
<p class="MsoPlainText" style="margin-left:.5in"><span
style="font-size:10.0pt;font-family:"Helvetica",sans-serif"> </span></p>
<p class="MsoPlainText" style="margin-left:.5in"><span
style="font-size:10.0pt;font-family:"Helvetica",sans-serif">There
was an issue with when PostgreSQL 10 came
out that the stack builder did not show the
PostGIS spatial extension I had uploaded.</span></p>
<p class="MsoPlainText" style="margin-left:.5in"><span
style="font-size:10.0pt;font-family:"Helvetica",sans-serif">This
was fixed in PostgreSQL 10.1 so perhaps you
went to it pre-10.1.</span></p>
<p class="MsoPlainText" style="margin-left:.5in"><span
style="font-size:10.0pt;font-family:"Helvetica",sans-serif"> </span></p>
<p class="MsoPlainText" style="margin-left:.5in"><span
style="font-size:10.0pt;font-family:"Helvetica",sans-serif">Regarding
not creating spatial db, that is odd. There
is a checkbox to create one, but I do have
it unchecked by default, cause it's better
for people to just use CREATE EXTENSION on
whatever database they want. I keep that
feature there just so I can test when I
deploy to make sure all extensions can be
created.</span></p>
<p class="MsoPlainText" style="margin-left:.5in"><span
style="font-size:10.0pt;font-family:"Helvetica",sans-serif"> </span></p>
<p class="MsoPlainText" style="margin-left:.5in"><span
style="font-size:10.0pt;font-family:"Helvetica",sans-serif">As
noted by Bo below, BigSQL packages PostGIS
too and that one IS NOT VIA STACKBUILDER.
STACKBUILDER is for EDB installs.</span></p>
<p class="MsoPlainText" style="margin-left:.5in"><span
style="font-size:10.0pt;font-family:"Helvetica",sans-serif"> </span></p>
<p class="MsoPlainText" style="margin-left:.5in"><span
style="font-size:10.0pt;font-family:"Helvetica",sans-serif">Use
pgc commandline or pgDevOps for BigSQL.</span></p>
<p class="MsoPlainText" style="margin-left:.5in"><span
style="font-size:10.0pt;font-family:"Helvetica",sans-serif"> </span></p>
<p class="MsoPlainText" style="margin-left:.5in"><span
style="font-size:10.0pt;font-family:"Helvetica",sans-serif">However,
the EDB windows and BigSQL Windows binaries
are compatible (both compiled with mingw64),
so if you ever need anything you can't find
in BigSQL (pgRouting and SFCGAL come to
mind)</span></p>
<p class="MsoPlainText" style="margin-left:.5in"><span
style="font-size:10.0pt;font-family:"Helvetica",sans-serif"> </span></p>
<p class="MsoPlainText" style="margin-left:.5in"><span
style="font-size:10.0pt;font-family:"Helvetica",sans-serif">You
can use the zip binaries on this page –</span></p>
<p class="MsoPlainText" style="margin-left:.5in"><span
style="font-size:10.0pt;font-family:"Helvetica",sans-serif"> </span></p>
<p class="MsoPlainText" style="margin-left:.5in"><span
style="font-size:10.0pt;font-family:"Helvetica",sans-serif"><a
href="https://postgis.net/windows_downloads/" moz-do-not-send="true">https://postgis.net/windows_downloads/</a></span></p>
<p class="MsoPlainText" style="margin-left:.5in"><span
style="font-size:10.0pt;font-family:"Helvetica",sans-serif"> </span></p>
<p class="MsoPlainText" style="margin-left:.5in"><span
style="font-size:10.0pt;font-family:"Helvetica",sans-serif"> </span></p>
<p class="MsoPlainText" style="margin-left:.5in"><span
style="font-size:10.0pt;font-family:"Helvetica",sans-serif">Thanks,</span></p>
<p class="MsoPlainText" style="margin-left:.5in"><span
style="font-size:10.0pt;font-family:"Helvetica",sans-serif">Regina</span></p>
<p class="MsoPlainText" style="margin-left:.5in"><span
style="font-size:10.0pt;font-family:"Helvetica",sans-serif"> </span></p>
<p class="MsoPlainText" style="margin-left:.5in"><span
style="font-size:10.0pt;font-family:"Helvetica",sans-serif"> </span></p>
<p class="MsoNormal" style="margin-left:.5in"><span
style="color:#1f497d"> </span></p>
<p class="MsoNormal" style="margin-left:.5in"><span
style="color:#1f497d"> </span></p>
<div>
<div style="border:none;border-top:solid
#e1e1e1 1.0pt;padding:3.0pt 0in 0in 0in">
<p class="MsoNormal"
style="margin-left:1.0in"><b>From:</b>
postgis-users [mailto:<a
href="mailto:postgis-users-bounces@lists.osgeo.org"
moz-do-not-send="true">postgis-users-bounces@lists.osgeo.org</a>]
<b>On Behalf Of </b>Bo Victor Thomsen<br>
<b>Sent:</b> Monday, December 11, 2017
4:14 AM<br>
<b>To:</b> <a
href="mailto:postgis-users@lists.osgeo.org"
moz-do-not-send="true">postgis-users@lists.osgeo.org</a><br>
<b>Subject:</b> Re: [postgis-users] Given
up</p>
</div>
</div>
<p class="MsoNormal" style="margin-left:1.0in"> </p>
<p style="margin-left:1.0in"><span
style="font-size:10.0pt;font-family:"Helvetica",sans-serif">Hi
Darrel -</span></p>
<p style="margin-left:1.0in"><span
style="font-size:10.0pt;font-family:"Helvetica",sans-serif">As
you already have found an alternative
installation, this mail is just a heads-up
for future users of the BigSQL installation
of PostgreSQL:</span></p>
<p class="MsoNormal" style="margin-left:1.5in"><span
style="font-size:10.0pt;font-family:Symbol">·</span><span
style="font-size:7.0pt"> </span>The
BigSQL administrative interface is based on
some kind of local http-server software, which
serves a JavaScript based program for
installing/upgrading PostgreSQL and extensions
(localhost:8051 IIRC)</p>
<p class="MsoNormal" style="margin-left:1.5in"><span
style="font-size:10.0pt;font-family:Symbol">·</span><span
style="font-size:7.0pt"> </span>This
works very nicely (some times). But depending
on your choice of antivirus - it can be a
*royal* pain, because *your* antivirus
software a lot of the time will stop *you*
from using the interface. </p>
<p class="MsoNormal" style="margin-left:1.5in"><span
style="font-size:10.0pt;font-family:Symbol">·</span><span
style="font-size:7.0pt"> </span>However,
BigSQL has an alternative installation method:
the <b>pgc</b> command line interface.</p>
<p class="MsoNormal" style="margin-left:1.5in"><span
style="font-size:10.0pt;font-family:Symbol">·</span><span
style="font-size:7.0pt"> </span>You
can do the following:</p>
<p class="MsoNormal" style="margin-left:2.0in"><span
style="font-size:10.0pt;font-family:"Courier New"">o</span><span
style="font-size:7.0pt"> </span>Start a
DOS box with administrative rights
(Right-click the dox-box icon, choose "Run as
Administrator")</p>
<p class="MsoNormal" style="margin-left:2.0in"><span
style="font-size:10.0pt;font-family:"Courier New"">o</span><span
style="font-size:7.0pt"> </span>In the
dos box, navigate to the installation
directory of BigSQL, usually c:\PostgreSQL or
c:\BigSQL</p>
<p class="MsoNormal" style="margin-left:2.0in"><span
style="font-size:10.0pt;font-family:"Courier New"">o</span><span
style="font-size:7.0pt"> </span>type
"pgc" . This will give you a list of supported
command for pgc.</p>
<p class="MsoNormal" style="margin-left:2.0in"><span
style="font-size:10.0pt;font-family:"Courier New"">o</span><span
style="font-size:7.0pt"> </span>Example -
Install the PostGIS 2.4 extension for
PostgreSQL: type "<b>pgc install
postgis24-pg10</b>"</p>
<p class="MsoNormal" style="margin-left:2.0in"><span
style="font-size:10.0pt;font-family:"Courier New"">o</span><span
style="font-size:7.0pt"> </span>Give it a
minute to download and install and then:
Voila! you have the PostGIS extension for
PostgreSQL installed and ready for use.</p>
<p class="MsoNormal"
style="margin-bottom:12.0pt;margin-left:1.0in">Regards<br>
Bo Victor Thomsen<br>
LIFA A/S, Denmark<br>
</p>
<div>
<p class="MsoNormal" style="margin-left:1.0in">Den
10-12-2017 kl. 20:29 skrev Darrel Maddy:</p>
</div>
<blockquote
style="margin-top:5.0pt;margin-bottom:5.0pt">
<p class="MsoNormal" style="margin-left:1.0in">Dear
all,</p>
<p class="MsoNormal" style="margin-left:1.0in"> </p>
<p class="MsoNormal" style="margin-left:1.0in">This
is probably not the best time for me to be
writing this but I think it is sometimes
useful to report negative outcomes.</p>
<p class="MsoNormal" style="margin-left:1.0in"> </p>
<p class="MsoNormal" style="margin-left:1.0in">I
have a new laptop running windows 10. I have
not installed postgresql or postgis for some
time so I decided to use the binaries. Using
the BIGSQL download proved to be a
nightmare. Postgresql 10 installs without
issue but with no stackbuilder option (it
does not appear anywhere in the menus nor in
the directories) I attempted to try and
install the postgis binaries. Needless to
say that failed with repeated errors for
files it could not find. I have spent a few
hours trying to convince this that the files
are there but now I have given up. To add
insult to injury the postgis uninstall did
not work and the postgresql uninstall failed
to remove most of its components. God knows
what mess it has made of any registry
entries (assuming it does that). I tried 9.6
but stackbuilder did not appear there either
so I have lost whatever patience I may have
started out with. I realise the install
instructions do not refer to the latest
versions but I reluctantly admit failure.
May be I just cannot follow instructions?</p>
<p class="MsoNormal" style="margin-left:1.0in"> </p>
<p class="MsoNormal" style="margin-left:1.0in">Perhaps
as I get older I forget previous experience
but I do not remember it being such a mess
previously. Maybe I will try again in a
month or two – is the situation likely to
improve? </p>
<p class="MsoNormal" style="margin-left:1.0in"> </p>
<p class="MsoNormal" style="margin-left:1.0in">Sorry
but I needed to get this off my chest and
the criticism is NOT aimed at anyone in
particular.</p>
<p class="MsoNormal" style="margin-left:1.0in"> </p>
<p class="MsoNormal" style="margin-left:1.0in">Darrel</p>
<p class="MsoNormal" style="margin-left:1.0in"> </p>
<p class="MsoNormal"
style="margin-bottom:12.0pt;margin-left:1.0in"><br>
<br>
</p>
<pre style="margin-left:1.0in">_______________________________________________</pre>
<pre style="margin-left:1.0in">postgis-users mailing list</pre>
<pre style="margin-left:1.0in"><a href="mailto:postgis-users@lists.osgeo.org" moz-do-not-send="true">postgis-users@lists.osgeo.org</a></pre>
<pre style="margin-left:1.0in"><a href="https://lists.osgeo.org/mailman/listinfo/postgis-users" moz-do-not-send="true">https://lists.osgeo.org/mailman/listinfo/postgis-users</a></pre>
</blockquote>
<p class="MsoNormal" style="margin-left:1.0in"> </p>
</div>
<p class="MsoNormal" style="margin-left:.5in"><span
style="font-size:10.0pt;font-family:"Helvetica",sans-serif">_______________________________________________<br>
postgis-users mailing list<br>
<a href="mailto:postgis-users@lists.osgeo.org"
moz-do-not-send="true">postgis-users@lists.osgeo.org</a><br>
<a
href="https://lists.osgeo.org/mailman/listinfo/postgis-users"
moz-do-not-send="true">https://lists.osgeo.org/mailman/listinfo/postgis-users</a></span></p>
</div>
</div>
</blockquote>
</div>
_______________________________________________<br>
postgis-users mailing list<br>
<a href="mailto:postgis-users@lists.osgeo.org"
moz-do-not-send="true">postgis-users@lists.osgeo.org</a><br>
<a
href="https://lists.osgeo.org/mailman/listinfo/postgis-users"
moz-do-not-send="true">https://lists.osgeo.org/mailman/listinfo/postgis-users</a></div>
</div>
</span></blockquote>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">_______________________________________________
postgis-users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:postgis-users@lists.osgeo.org">postgis-users@lists.osgeo.org</a>
<a class="moz-txt-link-freetext" href="https://lists.osgeo.org/mailman/listinfo/postgis-users">https://lists.osgeo.org/mailman/listinfo/postgis-users</a></pre>
</blockquote>
<br>
</body>
</html>