Skip site navigation (1) Skip section navigation (2)

Re: Problem starting pgsql server on Mac OS X. Pg_hba.conf reading permission.

From: Michael Wood <esiotrot(at)gmail(dot)com>
To: nextstopsun <nextstopsun(at)gmail(dot)com>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: Problem starting pgsql server on Mac OS X. Pg_hba.conf reading permission.
Date: 2009-09-01 15:10:29
Message-ID: 5a8aa6680909010810l6b9b66cfg97b75f5563769026@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-novice
2009/8/31 nextstopsun <nextstopsun(at)gmail(dot)com>:
[...]
> Then server doesn’t start – start server.app exits with non-zero value.
> Command line returns
> -------------
> BigMac:~ postgres$ FATAL:  data directory "/usr/local/pgsql/data" has group
> or world access
> DETAIL:  Permissions should be u=rwx (0700).
>
> chmod 700 /usr/local/pgsql/data/
> BigMac:~ postgres$ /usr/local/pgsql/bin/pg_ctl start -D
> /usr/local/pgsql/data
>
> server starting
> BigMac:~ postgres$ LOG:  could not open configuration file
> "/usr/local/pgsql/data/pg_hba.conf": Permission denied
> FATAL:  could not load pg_hba.conf
> -------------

What does this give you:

$ ls -ld /usr/local/pgsql/data/

Also:

$ ls -l /usr/local/pgsql/data/pg_hbs.conf

Maybe the postgres user is not the owner of that directory.

-- 
Michael Wood <esiotrot(at)gmail(dot)com>

In response to

Responses

pgsql-novice by date

Next:From: Michael WoodDate: 2009-09-01 15:11:19
Subject: Re: Problem starting pgsql server on Mac OS X. Pg_hba.conf reading permission.
Previous:From: Guillaume SmetDate: 2009-09-01 06:54:02
Subject: Re: psql: FATAL: the database system is in recovery mode

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group