On Aug 31, 2009, at 5:24 AM, NNL wrote:
> 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/
> 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
Most likely because the user you are using (appears to be postgres
from the prompt) is not the owner of file (and database). This would
be the case if initdb was run as a different user than postgres. Run
"ls -al" to check. So your options are to change the ownership of the
files, or run as the user which already owns them. Something like
sudo -u username /usr/local/pgsql/bin/pg_ctl start -D /usr/local/pgsql/
John DeSoi, Ph.D.
In response to
pgsql-general by date
|Next:||From: Erwin Brandstetter||Date: 2009-08-31 17:54:48|
|Subject: Re: Import data from XML file|
|Previous:||From: Tim Landscheidt||Date: 2009-08-31 17:00:27|
|Subject: Re: Query and the number of row result|