pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  

help / color / mirror / Atom feed

From: Rafael Martinez <r.m.guerrero@usit.uio.no>
To: bakkiya <bakkiya@gmail.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: Re: could not open temporary statistics file "pg_stat_tmp/pgstat.tmp"
Date: Thu, 16 Jun 2011 08:53:33 +0200
Message-ID: <4DF9A86D.7080301@usit.uio.no> (raw)
In-Reply-To: <1308206643749-4493814.post@n5.nabble.com>
References: <1308202086880-4493683.post@n5.nabble.com>
	<BANLkTi=nKMkQzOD9ZZi3ZNEGyMxwAeJXow@mail.gmail.com>
	<1308206643749-4493814.post@n5.nabble.com>

-----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-----

view thread (12+ messages)  latest in thread

Message-ID: <4DF9A86D.7080301@usit.uio.no>
Permalink:  ../4DF9A86D.7080301@usit.uio.no/
Also on:    postgresql.org/message-id/4DF9A86D.7080301@usit.uio.no

copy link · copy postgr.es

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-admin@postgresql.org
  Cc: r.m.guerrero@usit.uio.no, bakkiya@gmail.com
  Subject: Re: Re: could not open temporary statistics file "pg_stat_tmp/pgstat.tmp"
  In-Reply-To: <4DF9A86D.7080301@usit.uio.no>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

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