My PostGIS distribution is made for my Postgres distribution. It will not install for the EnterpriseDB distribution, and even if you could extract PostGIS and install it where EnterpriseDB wants it, it probably won't work.
I think they have a build of PostGIS that works with their Postgres. On Mar 5, 2011, at 6:14 PM, Rosemary Alles wrote: > I believe I figured it out, the Mac OS X install wiz for postgresql defaults > to /Library/PostgreSQL/ (which I accepted) and the install wiz for postgis > appears to *only* look in /usr/local/ to determine if postgresql has > *already* been installed, hence one of two things must happen: > • postgresql installing *must* happen in /usr/local or > • create a symbolic link from /usr/local to where the preferred > installation location (for postgresql) and the installation for postgis > follows without a problem (without which it fails complaining it needs > postgresql.) > • Is this is a simple matter of un-tarring a compressed file, - then no > biggie anyway... > Thanks for your help, > rosemary. > > On Sat, Mar 5, 2011 at 3:30 PM, Rosemary Alles <rosemary.al...@gmail.com> > wrote: > Thanks William. > > I redid the installation (by *actually* reading the readme -duh- and things > appear to be working). > > The installation, uses an install wiz which asks for the password, etc. > (system password for the user postgres vs the db password) - the installation > proceeds ok as long as shared mem has been set (as required) and the system > rebooted to register the change *prior* to installation. > > Anyway, I need to install PostGIS on top of this, and wonder where (which > directory under /Library/PostgreSQL/9.0/ I should untar the PostGIS binaries > from: http://www.kyngchaos.com/software:postgres? > > Thanks much, > rosemary. > > > On Sat, Mar 5, 2011 at 8:54 AM, William Kyngesburye <wokl...@kyngchaos.com> > wrote: > On Mar 5, 2011, at 4:38 AM, Rosemary Alles wrote: > > > Hullo all, > > > > After running around in circles for a bit, I decide I would ask. The > > installation of PostgreSQL from > > http://www.enterprisedb.com/products-services-training/pgdownload#osx > > apparently created a user "postgres" (with no home directory - but that's > > ok) and if there's a password (maybe there isn't one?) then I have no idea > > what it is... I had to enable root to get into the data directory (su - > > postgress), now I'm assuming I have to edit pg_hba.conf (to change/set the > > password - authenticate users/roles) before I can do anything else? > > > This is normal. (I *do* have this info in my Postgres distribution) There > is no password, but it's a special null password, not an empty password, so > it can't be used to login to anything. It's a user solely used for running > Postgres. But you can force authentication (for editing the config files) > with root. > > > > Still, the current config is as follows, which appears to grant access to > > "all" w/trust? If so, why am I getting an error upon trying to create a DB > > as myself/admin? > > > > # TYPE DATABASE USER CIDR-ADDRESS METHOD > > # "local" is for Unix domain socket connections only > > local all all trust > > # IPv4 local connections: > > host all all 127.0.0.1/32 trust > > # IPv6 local connections: > > host all all ::1/128 trust > > > > error: > > createdb: could not connect to database postgres: FATAL: role > > "whatever_name" does not > > > > exist > > > Have you set up any postgres users, "roles", yet? Postgres doesn't use > system users. A "postgres" role is created on initialization (independent of > the system postgres user). Use that to create other roles and to manage > other stuff. > > > Check the Postgres documentation and other help resources for more details. > My Postgres distribution has some basics, to get people started. > > > > Any help is good, > > rosemary. > > > > > > _______________________________________________ > > postgis-users mailing list > > postgis-users@postgis.refractions.net > > http://postgis.refractions.net/mailman/listinfo/postgis-users > > ----- > William Kyngesburye <kyngchaos*at*kyngchaos*dot*com> > http://www.kyngchaos.com/ > > The equator is so long, it could encircle the earth completely once. > > > > _______________________________________________ > postgis-users mailing list > postgis-users@postgis.refractions.net > http://postgis.refractions.net/mailman/listinfo/postgis-users ----- William Kyngesburye <kyngchaos*at*kyngchaos*dot*com> http://www.kyngchaos.com/ All generalizations are dangerous, even this one. _______________________________________________ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
