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

[William Kyngesburye]

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.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#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 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.
> 
> 
> 
> _______________________________________________
> 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/

All generalizations are dangerous, even this one.