[postgis-users] Given up

Tijan49 tijan49 at yahoo.fr
Mon Dec 11 08:55:34 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 à 14:40, Anthony DeBarros a écrit :
> 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 NOT 
>> 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
> 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/250abab5/attachment.html>

More information about the postgis-users mailing list