Re: Re: could not open temporary statistics file "pg_stat_tmp/pgstat.tmp" - Mailing list pgsql-admin

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On 06/16/2011 08:44 AM, bakkiya wrote:

>
> postgresql/data/pg_stat_tmp> touch a
> novell@s210:/pub/var/opt/novell/sentinel/3rdparty/postgresql/data/pg_stat_tmp>
> ls -rtl
> total 96
> -rw------- 1 novell novell 91898 2011-06-15 23:36 pgstat.stat
> -rw-r--r-- 1 novell novell     0 2011-06-15 23:36 a
>

Hei

Are you running postgres with the user 'novell' or 'postgres'?
The user running postgres must own the directories with the data.

regards,
- --
 Rafael Martinez Guerrero
 Center for Information Technology
 University of Oslo, Norway

 PGP Public Key: http://folk.uio.no/rafael/
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v2.0.14 (GNU/Linux)

iEYEARECAAYFAk35qG0ACgkQBhuKQurGihRuQQCgmxS8JsGnYm4SdGZZt85RLjq6
MroAn0jy5NKxZrTinHqQfCnUPMUS70SS
=l2ef
-----END PGP SIGNATURE-----