pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedPGDATA not accessible; please fix the directory permissions ($PGDATA should be world readable)
3+ messages / 2 participants
[nested] [flat]
* PGDATA not accessible; please fix the directory permissions ($PGDATA should be world readable)
@ 2011-08-09 14:49 jtkells@verizon.net
2011-08-09 15:20 ` Re: PGDATA not accessible; please fix the directory permissions ($PGDATA should be world readable) jtkells@verizon.net
2011-08-09 15:49 ` Re: PGDATA not accessible; please fix the directory permissions ($PGDATA should be world readable) Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 2 replies; 3+ messages in thread
From: jtkells@verizon.net @ 2011-08-09 14:49 UTC (permalink / raw)
To: pgsql-admin
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
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: PGDATA not accessible; please fix the directory permissions ($PGDATA should be world readable)
2011-08-09 14:49 PGDATA not accessible; please fix the directory permissions ($PGDATA should be world readable) jtkells@verizon.net
@ 2011-08-09 15:20 ` jtkells@verizon.net
1 sibling, 0 replies; 3+ messages in thread
From: jtkells@verizon.net @ 2011-08-09 15:20 UTC (permalink / raw)
To: pgsql-admin
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
>
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: PGDATA not accessible; please fix the directory permissions ($PGDATA should be world readable)
2011-08-09 14:49 PGDATA not accessible; please fix the directory permissions ($PGDATA should be world readable) jtkells@verizon.net
@ 2011-08-09 15:49 ` Tom Lane <tgl@sss.pgh.pa.us>
1 sibling, 0 replies; 3+ messages in thread
From: Tom Lane @ 2011-08-09 15:49 UTC (permalink / raw)
To: jtkells@verizon.net; +Cc: pgsql-admin
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
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2011-08-09 15:49 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2011-08-09 14:49 PGDATA not accessible; please fix the directory permissions ($PGDATA should be world readable) jtkells@verizon.net
2011-08-09 15:20 ` jtkells@verizon.net
2011-08-09 15:49 ` Tom Lane <tgl@sss.pgh.pa.us>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox