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:11:19
Message-ID: 5a8aa6680909010811v261b6c48y9a19aed21f871150@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-novice
2009/9/1 Michael Wood <esiotrot(at)gmail(dot)com>:
> 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

Of course, I meant /usr/local/pgsql/data/pg_hba.conf.

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

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

In response to

pgsql-novice by date

Next:From: Adam WałachDate: 2009-09-01 15:12:14
Subject: Variadic functions and name
Previous:From: Michael WoodDate: 2009-09-01 15:10:29
Subject: Re: Problem starting pgsql server on Mac OS X. Pg_hba.conf reading permission.

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