From: | Pawel Socha <pawel(dot)socha(at)gmail(dot)com> |
---|---|
To: | nextstopsun <nextstopsun(at)gmail(dot)com> |
Cc: | pgsql-admin(at)postgresql(dot)org |
Subject: | Re: Problem starting pgsql server on Mac OS X. Pg_hba.conf reading permission. |
Date: | 2009-09-21 06:36:40 |
Message-ID: | cc4f12900909202336j36c40e1dhce6735f74004f201@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
2009/8/31 nextstopsun <nextstopsun(at)gmail(dot)com>:
>
> 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?
>
> --
> View this message in context: http://www.nabble.com/Problem-starting-pgsql-server-on-Mac-OS-X.-Pg_hba.conf-reading-permission.-tp25220784p25220784.html
> Sent from the PostgreSQL - admin mailing list archive at Nabble.com.
>
>
> --
> Sent via pgsql-admin mailing list (pgsql-admin(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-admin
>
add postgres user in osx ;]
Solution:
http://www.postgresql.org/docs/8.3/interactive/postgres-user.html
;]
--
Pawel Socha
From | Date | Subject | |
---|---|---|---|
Next Message | Paweł Nieścioruk | 2009-09-21 09:08:57 | pg_hba.conf problem in PostgreSQL 8.4 (no-installer) |
Previous Message | abhishekgautam009 | 2009-09-21 02:47:22 | Re: Help with Error |