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

Rosemary Alles rosemary.alles at gmail.com
Sat Mar 5 02:38:42 PST 2011

Hullo all,

After running around in circles for a bit, I decide I would ask. The
installation of PostgreSQL from
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               trust
# IPv6 local connections:
host    all             all             ::1/128                 trust


createdb: could not connect to database postgres: FATAL:  role
"whatever_name" does not

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

More information about the postgis-users mailing list