Обсуждение: PGDATA not accessible; please fix the directory permissions ($PGDATA should be world readable)

postgresql 8.4.8 64 bit /Ubuntu 10.4 64 bit

When I try to connect to postgresql from a local user on the same
machine that postgresql is running on I receive the following:
psql
Error: /pgdata/data is not accessible; please fix the directory
permissions (/pgdata/ should be world readable)

whats even worse if I try to connect to postgresql using localhost I
get the same problem
 psql -h localhost -p 5432 -d DB -U user1
Error:/pgdata/data not accessible; please fix the directory
permissions (/pgdata/ should be world readable)

I dont have this problem from the local postgres account nor do I have
any problem connecting to the database remotely using TCP/IP.

If I change the unix_socket_directory setting to  /tmp I get the
following error when I try to log on locally from postgres

psql: could not connect to server: No such file or directory
    Is the server running locally and accepting
    connections on Unix domain socket
"/var/run/postgresql/.s.PGSQL.5432"?

Not sure what is going on.

pg_hba
# "local" is for Unix domain socket connections only
local   all         all                               ident
# IPv4 local connections:
host    all         all         127.0.0.1/32          md5
host    all         all         192.0.0.0/8          md5

I found something out but not sure I understand why this is causing an
issue:
find / -name psql -print -exec ls -l {} \;
    /usr/bin/psql -> ../share/postgresql-common/pg_wrapper
    /usr/lib/postgresql/8.4/bin/psql

The search path was finding the first entry.  When I put the
"/usr/lib/postgresql/8.4/bin" path first in the PATH  variablepsql
works fine.  Does any one know why
../share/postgresql-common/pg_wrapper exists and why it would give me
a problem for non postgres Unix accounts?


Thanks
On Tue, 09 Aug 2011 10:49:27 -0400, jtkells@verizon.net wrote:

>
>
>postgresql 8.4.8 64 bit /Ubuntu 10.4 64 bit
>
>When I try to connect to postgresql from a local user on the same
>machine that postgresql is running on I receive the following:
>psql
>Error: /pgdata/data is not accessible; please fix the directory
>permissions (/pgdata/ should be world readable)
>
>whats even worse if I try to connect to postgresql using localhost I
>get the same problem
> psql -h localhost -p 5432 -d DB -U user1
>Error:/pgdata/data not accessible; please fix the directory
>permissions (/pgdata/ should be world readable)
>
>I dont have this problem from the local postgres account nor do I have
>any problem connecting to the database remotely using TCP/IP.
>
>If I change the unix_socket_directory setting to  /tmp I get the
>following error when I try to log on locally from postgres
>
>psql: could not connect to server: No such file or directory
>    Is the server running locally and accepting
>    connections on Unix domain socket
>"/var/run/postgresql/.s.PGSQL.5432"?
>
>Not sure what is going on.
>
>pg_hba
># "local" is for Unix domain socket connections only
>local   all         all                               ident
># IPv4 local connections:
>host    all         all         127.0.0.1/32          md5
>host    all         all         192.0.0.0/8          md5
>

jtkells@verizon.net writes:
> postgresql 8.4.8 64 bit /Ubuntu 10.4 64 bit

> When I try to connect to postgresql from a local user on the same
> machine that postgresql is running on I receive the following:
> psql
> Error: /pgdata/data is not accessible; please fix the directory
> permissions (/pgdata/ should be world readable)

There is no such error message in the standard distribution of Postgres.

I surmise that you are up against some hack written by the Ubuntu
packager of Postgres, and so you'd be best off filing a bug in the
Ubuntu bug tracker to get support for that.

            regards, tom lane