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.
_______________________________________________ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
