On 04/22/2014 07:11 AM, basti wrote:
When Postgres has no permission why "pgstat.stat" is created by postgres?
I have also try to create a file via su postgres -c "cd /run/shm/ &&
touch ...."
/run# ls -la shm
total 52
drwxrwxrwt 2 root root 100 Apr 22 16:09 .
drwxr-xr-x 20 root root 660 Apr 8 11:15 ..
-rw-r--r-- 1 postgres postgres 0 Apr 22 16:09
file_create_as_postgres_user
-rw------- 1 postgres postgres 52658 Apr 22 16:09 pgstat.stat
-rw-r--r-- 1 root root 0 Oct 19 2012 .tmpfs
/run# ls -rtl | grep shm
drwxrwxrwt 2 root root 80 Apr 22 16:02 shm
I think these permissions are enough.
What distribution are you running?
Is it possible you have something like SELinux enabled that is intervening?
What does the system log show when the Postgres server throws the error?
Basti
On 22.04.2014 15:36, Adrian Klaver wrote:
On 04/22/2014 02:39 AM, basti wrote:
Hello,
since I have enabled "stats_temp_directory = '/run/shm'" in
/etc/postgresql/9.1/main/postgresql.conf I get the following error:
2014-04-21 02:37:29 CEST LOG: could not rename temporary statistics
file "/run/shm/pgstat.tmp" to "/run/shm/pgstat.stat": No such file or
directory
/var/run/shm# ls -rtl
-rw------- 1 postgres postgres 312211 Apr 22 11:31 pgstat.stat
There is no "/run/shm/pgstat.tmp" file but if I create it and change the
owner to postgres the file will be removed few minutes later.
How can explain and how can I solve this "error"?
Postgres does not have permissions on the directory. Give Postgres
permissions on the directory.
Regards,
Basti
--
Adrian Klaver
adrian.klaver@xxxxxxxxxxx
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
