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:
1. postgresql installing *must* happen in /usr/local or 2. 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.) 3. 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#osxapparently >> 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
