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

Peripheral Links

Header And Logo

PostgreSQL
| The world's most advanced open source database.

Site Navigation

Search archives
  Advanced Search

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


  • From: NNL <nextstopsun(at)gmail(dot)com>
  • To: <pgsql-general(at)postgresql(dot)org>
  • Subject: Problem starting pgsql server on Mac OS X. Pg_hba.conf reading permission.
  • Date: Mon, 31 Aug 2009 13:24:27 +0400
  • Message-id: <C6C17F8B.295%nextstopsun@gmail.com> <text/plain>

Hello.
I¹m having a problem starting server on mac os x.

-------------
bash-3.2$ /usr/local/pgsql/bin/pg_ctl start -D /usr/local/pgsql/data
server starting
bash-3.2$ LOG:  could not open configuration file
"/usr/local/pgsql/data/pg_hba.conf": Permission denied
FATAL:  could not load pg_hba.conf
-------------

The problem appears after changing permissions for /data folder in finder. I
did this:

I¹m installing postgresql 8.4 from MacOS binary and it installs and starts
ok. Then I try to edit pg_hba.conf in pgAdmin3 to add a line
--------------
host    all         all         10.0.0.6              md5
--------------
After I click save icon to save a file it doesn¹t save ­ probably it doesn¹t
have enough permission for that. So I go to my /usr/local/pgsql/data/ folder
in Finder ­ unlock it¹s permissions and set read/write to everyone group.
Then I edit the pg_hba file with TextEdit.app and it looks like this

-------------
# "local" is for Unix domain socket connections only
local   all         all                               trust
# IPv4 local connections:
host    all         all         127.0.0.1/32          trust
host    all         all         10.0.0.6              md5
# IPv6 local connections:
host    all         all         ::1/128               trust
-------------

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
-------------

I¹ve tried installing postgre from source thru fink, and the problem stays
the same. I¹m really stuck here, and I really need postgre to be accessed
from 10.0.0.6 machine.
What am I doing wrong? As I understand it¹s a folder access permission
problem, but I don¹t know how to fix it. Can anyone PLEASE help me?





Home | Main Index | Thread Index

Privacy Policy | About PostgreSQL
Copyright © 1996 – 2012 PostgreSQL Global Development Group