[postgis-users] user postgres fiasco(?) on Mac OS X 10.6.6

[Rosemary Alles]

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.alles at 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 <woklist at 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 at 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.
>>
>>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20110305/d2315beb/attachment.html>