Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: Problem starting pgsql server on Mac OS X. Pg_hba.conf reading permission.
- From: John DeSoi <desoi(at)pgedit(dot)com>
- To: NNL <nextstopsun(at)gmail(dot)com>
- Cc: <pgsql-general(at)postgresql(dot)org>
- Subject: Re: Problem starting pgsql server on Mac OS X. Pg_hba.conf reading permission.
- Date: Mon, 31 Aug 2009 13:17:23 -0400
- Message-id: <4BF2EF36-E49E-4B50-885B-ABFBAD48F5D1@pgedit.com> <text/plain>
On Aug 31, 2009, at 5:24 AM, NNL wrote:
BigMac:~ postgres$ FATAL: data directory "/usr/local/pgsql/data" has group or world accessDETAIL: 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/dataserver startingBigMac:~ postgres$ LOG: could not open configuration file "/usr/ local/pgsql/data/pg_hba.conf": Permission deniedFATAL: 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/ data
John DeSoi, Ph.D.
- References:
- Prev by Date: Re: Query and the number of row result
- Next by Date: Re: Import data from XML file
- Previous by thread: Re: Problem starting pgsql server on Mac OS X. Pg_hba.conf reading permission.
- Next by thread: print/return only the first X chars of a varchar column?
- Indexes: