<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>
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>
Thanks,<br>
Jean<br>
<br>
Le 11/12/2017 à 14:40, Anthony DeBarros a écrit :<br>
</div>
<blockquote type="cite"
cite="mid:CAAQFaF+4E7x4QkpY8OM+jmftU3VLmPsfhq_ceYiXJAj8GqAM8w@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">Regina
(or anyone),</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">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?</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">Thanks,</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 8:23:31 AM, 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 bgcolor="white" link="#0563C1" vlink="#954F72"
lang="EN-US">
<div>
<div class="WordSection1">
<p class="MsoPlainText">Darrel,</p>
<p class="MsoPlainText"> </p>
<p class="MsoPlainText">There was an issue with when
PostgreSQL 10 came out that the stack builder did not
show the PostGIS spatial extension I had uploaded.</p>
<p class="MsoPlainText">This was fixed in PostgreSQL
10.1 so perhaps you went to it pre-10.1.</p>
<p class="MsoPlainText"> </p>
<p class="MsoPlainText">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.</p>
<p class="MsoPlainText"> </p>
<p class="MsoPlainText">As noted by Bo below, BigSQL
packages PostGIS too and that one IS NOT VIA
STACKBUILDER. STACKBUILDER is for EDB installs.</p>
<p class="MsoPlainText"> </p>
<p class="MsoPlainText">Use pgc commandline or pgDevOps
for BigSQL.</p>
<p class="MsoPlainText"> </p>
<p class="MsoPlainText">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)</p>
<p class="MsoPlainText"> </p>
<p class="MsoPlainText">You can use the zip binaries on
this page –</p>
<p class="MsoPlainText"> </p>
<p class="MsoPlainText"><a
href="https://postgis.net/windows_downloads/"
moz-do-not-send="true">https://postgis.net/windows_downloads/</a><span
style="color:#1f497d"></span></p>
<p class="MsoPlainText"> </p>
<p class="MsoPlainText"> </p>
<p class="MsoPlainText">Thanks,</p>
<p class="MsoPlainText">Regina</p>
<p class="MsoPlainText"> </p>
<p class="MsoPlainText"> </p>
<p class="MsoPlainText"> </p>
<p class="MsoNormal"><span style="color:#1f497d"> </span></p>
<p class="MsoNormal"><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:.5in"><b><span
style="color:windowtext">From:</span></b><span
style="color:windowtext"> 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</span></p>
</div>
</div>
<p class="MsoNormal" style="margin-left:.5in"> </p>
<p style="margin-left:.5in">Hi Darrel -<span
style="font-size:12.0pt"></span></p>
<p style="margin-left:.5in">As you already have found an
alternative installation, this mail is just a heads-up
for future users of the BigSQL installation of
PostgreSQL:</p>
<p class="MsoNormal" style="margin-left:1.0in"><span
style="font-size:10.0pt;font-family:Symbol"><span
style="mso-list:Ignore">·<span style="font:7.0pt
"Times New Roman""> </span></span></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.0in"><span
style="font-size:10.0pt;font-family:Symbol"><span
style="mso-list:Ignore">·<span style="font:7.0pt
"Times New Roman""> </span></span></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.0in"><span
style="font-size:10.0pt;font-family:Symbol"><span
style="mso-list:Ignore">·<span style="font:7.0pt
"Times New Roman""> </span></span></span>However,
BigSQL has an alternative installation method: the <b>pgc</b>
command line interface.</p>
<p class="MsoNormal" style="margin-left:1.0in"><span
style="font-size:10.0pt;font-family:Symbol"><span
style="mso-list:Ignore">·<span style="font:7.0pt
"Times New Roman""> </span></span></span>You
can do the following:</p>
<p class="MsoNormal" style="margin-left:1.5in"><span
style="font-size:10.0pt;font-family:"Courier
New""><span style="mso-list:Ignore">o<span
style="font:7.0pt "Times New Roman"">
</span></span></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:1.5in"><span
style="font-size:10.0pt;font-family:"Courier
New""><span style="mso-list:Ignore">o<span
style="font:7.0pt "Times New Roman"">
</span></span></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:1.5in"><span
style="font-size:10.0pt;font-family:"Courier
New""><span style="mso-list:Ignore">o<span
style="font:7.0pt "Times New Roman"">
</span></span></span>type "pgc" . This will give
you a list of supported command for pgc.</p>
<p class="MsoNormal" style="margin-left:1.5in"><span
style="font-size:10.0pt;font-family:"Courier
New""><span style="mso-list:Ignore">o<span
style="font:7.0pt "Times New Roman"">
</span></span></span>Example - Install the PostGIS
2.4 extension for PostgreSQL: type "<b>pgc install
postgis24-pg10</b>"</p>
<p class="MsoNormal" style="margin-left:1.5in"><span
style="font-size:10.0pt;font-family:"Courier
New""><span style="mso-list:Ignore">o<span
style="font:7.0pt "Times New Roman"">
</span></span></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-right:0in;margin-bottom:12.0pt;margin-left:.5in">Regards<br>
Bo Victor Thomsen<br>
LIFA A/S, Denmark<br>
</p>
<div>
<p class="MsoNormal" style="margin-left:.5in">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:.5in">Dear
all,</p>
<p class="MsoNormal" style="margin-left:.5in"> </p>
<p class="MsoNormal" style="margin-left:.5in">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:.5in"> </p>
<p class="MsoNormal" style="margin-left:.5in">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:.5in"> </p>
<p class="MsoNormal" style="margin-left:.5in">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:.5in"> </p>
<p class="MsoNormal" style="margin-left:.5in">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:.5in"> </p>
<p class="MsoNormal" style="margin-left:.5in">Darrel</p>
<p class="MsoNormal" style="margin-left:.5in"> </p>
<p class="MsoNormal" style="margin-left:.5in"><span
style="font-size:12.0pt;font-family:"Times
New Roman",serif"><br>
<br>
<br>
</span></p>
<pre style="margin-left:.5in">_______________________________________________</pre>
<pre style="margin-left:.5in">postgis-users mailing list</pre>
<pre style="margin-left:.5in"><a href="mailto:postgis-users@lists.osgeo.org" moz-do-not-send="true">postgis-users@lists.osgeo.org</a></pre>
<pre style="margin-left:.5in"><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:.5in"><span
style="font-size:12.0pt;font-family:"Times New
Roman",serif"> </span></p>
</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>