[postgis-users] Given up

Tijan49 tijan49 at yahoo.fr
Mon Dec 11 11:51:26 PST 2017


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 ...).
For that reason I came back to PostgreSQL 9.6.
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) ?


Le 11/12/2017 à 20:24, Anthony DeBarros a écrit :
> Thanks, Regina,
> Nope, Postgres.app doesn’t include it. Haven’t successfully found an 
> alternative.
> Anthony
> On December 11, 2017 at 1:17:19 PM, Regina Obe (lr at pcorp.us 
> <mailto:lr at pcorp.us>) wrote:
>> Anthony,
>> Sorry no clue about Mac.  I thought perhaps Postgres.app might have it
>> http://postgresapp.com/documentation/gui-tools.html
>> but don't see it listed under their Gui Client apps. It's possible 
>> they missed listing it and they have it.
>> I see the PostGIS commandline tools listed under CLI apps though
>> http://postgresapp.com/documentation/cli-tools.html
>> Thanks,
>> Regina
>> *From:*postgis-users [mailto:postgis-users-bounces at lists.osgeo.org 
>> <mailto:postgis-users-bounces at lists.osgeo.org>] *On Behalf Of 
>> *Anthony DeBarros
>> *Sent:* Monday, December 11, 2017 8:41 AM
>> *To:* PostGIS Users Discussion <postgis-users at lists.osgeo.org 
>> <mailto:postgis-users at lists.osgeo.org>>
>> *Subject:* Re: [postgis-users] Given up
>> Regina (or anyone),
>> 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?
>> Thanks,
>> Anthony
>> On December 11, 2017 at 8:23:31 AM, Regina Obe (lr at pcorp.us 
>> <mailto:lr at pcorp.us>) wrote:
>>     Darrel,
>>     There was an issue with when PostgreSQL 10 came out that the
>>     stack builder did not show the PostGIS spatial extension I had
>>     uploaded.
>>     This was fixed in PostgreSQL 10.1 so perhaps you went to it pre-10.1.
>>     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.
>>     As noted by Bo below, BigSQL packages PostGIS too and that one IS
>>     Use pgc commandline or pgDevOps for BigSQL.
>>     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)
>>     You can use the zip binaries on this page –
>>     https://postgis.net/windows_downloads/
>>     Thanks,
>>     Regina
>>     *From:* postgis-users
>>     [mailto:postgis-users-bounces at lists.osgeo.org
>>     <mailto:postgis-users-bounces at lists.osgeo.org>] *On Behalf Of *Bo
>>     Victor Thomsen
>>     *Sent:* Monday, December 11, 2017 4:14 AM
>>     *To:* postgis-users at lists.osgeo.org
>>     <mailto:postgis-users at lists.osgeo.org>
>>     *Subject:* Re: [postgis-users] Given up
>>     Hi Darrel -
>>     As you already have found an alternative installation, this mail
>>     is just a heads-up for future users of the BigSQL installation of
>>     PostgreSQL:
>>     ·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)
>>     ·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.
>>     ·However, BigSQL has an alternative installation method: the
>>     *pgc* command line interface.
>>     ·You can do the following:
>>     oStart a DOS box with administrative rights (Right-click the
>>     dox-box icon, choose "Run as Administrator")
>>     oIn the dos box, navigate to the installation directory of
>>     BigSQL, usually c:\PostgreSQL or c:\BigSQL
>>     otype "pgc" . This will give you a list of supported command for pgc.
>>     oExample - Install the PostGIS 2.4 extension for PostgreSQL: type
>>     "*pgc install postgis24-pg10*"
>>     oGive it a minute to download and install and then: Voila! you
>>     have the PostGIS extension for PostgreSQL installed and ready for
>>     use.
>>     Regards
>>     Bo Victor Thomsen
>>     LIFA A/S, Denmark
>>     Den 10-12-2017 kl. 20:29 skrev Darrel Maddy:
>>         Dear all,
>>         This is probably not the best time for me to be writing this
>>         but I think it is sometimes useful to report negative outcomes.
>>         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?
>>         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?
>>         Sorry but I needed to get this off my chest and the criticism
>>         is NOT aimed at anyone in particular.
>>         Darrel
>>         _______________________________________________
>>         postgis-users mailing list
>>         postgis-users at lists.osgeo.org
>>         <mailto:postgis-users at lists.osgeo.org>
>>         https://lists.osgeo.org/mailman/listinfo/postgis-users
>>     _______________________________________________
>>     postgis-users mailing list
>>     postgis-users at lists.osgeo.org <mailto:postgis-users at lists.osgeo.org>
>>     https://lists.osgeo.org/mailman/listinfo/postgis-users
>> _______________________________________________
>> postgis-users mailing list
>> postgis-users at lists.osgeo.org <mailto:postgis-users at lists.osgeo.org>
>> https://lists.osgeo.org/mailman/listinfo/postgis-users
> _______________________________________________
> postgis-users mailing list
> postgis-users at lists.osgeo.org
> https://lists.osgeo.org/mailman/listinfo/postgis-users

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20171211/9d9317c1/attachment.html>

More information about the postgis-users mailing list