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:<br>
<ol><li>postgresql installing *must* happen in /usr/local or</li><li>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.)</li>
<li>Is this is a simple matter of un-tarring a compressed file, - then no biggie anyway... <br></li></ol>Thanks for your help,<br>rosemary.<br><br><div class="gmail_quote">On Sat, Mar 5, 2011 at 3:30 PM, Rosemary Alles <span dir="ltr"><<a href="mailto:rosemary.alles@gmail.com">rosemary.alles@gmail.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;">Thanks William.<br><br>I redid the installation (by *actually* reading the readme -duh- and things appear to be working).<br>
<br>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.<br>
<br>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: <a href="http://www.kyngchaos.com/software:postgres" target="_blank">http://www.kyngchaos.com/software:postgres</a>? <br>
<br>Thanks much,<br><font color="#888888">rosemary.</font><div><div></div><div class="h5"><br><br><div class="gmail_quote">On Sat, Mar 5, 2011 at 8:54 AM, William Kyngesburye <span dir="ltr"><<a href="mailto:woklist@kyngchaos.com" target="_blank">woklist@kyngchaos.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;">
<div>On Mar 5, 2011, at 4:38 AM, Rosemary Alles wrote:<br>
<br>
> Hullo all,<br>
><br>
> After running around in circles for a bit, I decide I would ask. The installation of PostgreSQL from <a href="http://www.enterprisedb.com/products-services-training/pgdownload#osx" target="_blank">http://www.enterprisedb.com/products-services-training/pgdownload#osx</a> 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?<br>
><br>
</div>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.<br>
<div><br>
<br>
> 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?<br>
><br>
> # TYPE DATABASE USER CIDR-ADDRESS METHOD<br>
> # "local" is for Unix domain socket connections only<br>
> local all all trust<br>
> # IPv4 local connections:<br>
> host all all <a href="http://127.0.0.1/32" target="_blank">127.0.0.1/32</a> trust<br>
> # IPv6 local connections:<br>
> host all all ::1/128 trust<br>
><br>
> error:<br>
> createdb: could not connect to database postgres: FATAL: role "whatever_name" does not<br>
><br>
> exist<br>
><br>
</div>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.<br>
<br>
<br>
Check the Postgres documentation and other help resources for more details. My Postgres distribution has some basics, to get people started.<br>
<div><br>
<br>
> Any help is good,<br>
> rosemary.<br>
><br>
><br>
</div>> _______________________________________________<br>
> postgis-users mailing list<br>
> <a href="mailto:postgis-users@postgis.refractions.net" target="_blank">postgis-users@postgis.refractions.net</a><br>
> <a href="http://postgis.refractions.net/mailman/listinfo/postgis-users" target="_blank">http://postgis.refractions.net/mailman/listinfo/postgis-users</a><br>
<br>
-----<br>
William Kyngesburye <kyngchaos*at*kyngchaos*dot*com><br>
<a href="http://www.kyngchaos.com/" target="_blank">http://www.kyngchaos.com/</a><br>
<br>
The equator is so long, it could encircle the earth completely once.<br>
<br>
</blockquote></div><br>
</div></div></blockquote></div><br>