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

[Rosemary Alles]

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?

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

 Any help is good,
rosemary.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20110305/276cf770/attachment.html>