Received: from maia.hub.org (maia-3.hub.org [200.46.204.243]) by mail.postgresql.org (Postfix) with ESMTP id 40964B5D803 for ; Thu, 16 Jun 2011 03:53:42 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.243]) (amavisd-maia, port 10024) with ESMTP id 67797-01 for ; Thu, 16 Jun 2011 06:53:35 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from mail-out1.uio.no (mail-out1.uio.no [129.240.10.57]) by mail.postgresql.org (Postfix) with ESMTP id 65E5CB5D91F for ; Thu, 16 Jun 2011 03:53:35 -0300 (ADT) Received: from mail-mx3.uio.no ([129.240.10.44]) by mail-out1.uio.no with esmtp (Exim 4.75) (envelope-from ) id 1QX6SM-00033H-6e; Thu, 16 Jun 2011 08:53:34 +0200 Received: from bbking.uio.no ([129.240.6.205]) by mail-mx3.uio.no with esmtpsa (TLSv1:CAMELLIA256-SHA:256) user rafael (Exim 4.76) (envelope-from ) id 1QX6SL-0003kC-OS; Thu, 16 Jun 2011 08:53:34 +0200 Message-ID: <4DF9A86D.7080301@usit.uio.no> Date: Thu, 16 Jun 2011 08:53:33 +0200 From: Rafael Martinez Organization: University of Oslo User-Agent: Mozilla/5.0 (X11; U; Linux x86_64; en-US; rv:1.9.2.17) Gecko/20110419 Red Hat/3.1.10-1.el6_0 Thunderbird/3.1.10 MIME-Version: 1.0 To: bakkiya CC: pgsql-admin@postgresql.org Subject: Re: Re: could not open temporary statistics file "pg_stat_tmp/pgstat.tmp" References: <1308202086880-4493683.post@n5.nabble.com> <1308206643749-4493814.post@n5.nabble.com> In-Reply-To: <1308206643749-4493814.post@n5.nabble.com> X-Enigmail-Version: 1.1.2 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit X-UiO-Ratelimit-Test: rcpts/h 3 msgs/h 2 sum rcpts/h 4 sum msgs/h 3 total rcpts 2545 max rcpts/h 15 ratelimit 0 X-UiO-Spam-info: not spam, SpamAssassin (score=-8.0, required=5.0, autolearn=disabled, T_RP_MATCHES_RCVD=-0.01, UIO_MAIL_IS_INTERNAL=-5, UIO_PGP_SIGNED=-3, uiobl=NO, uiouri=NO) X-UiO-Scanned: 314E9367E5D6D855ACC0F185E2B3AE687ADBF320 X-UiO-SPAM-Test: remote_host: 129.240.6.205 spam_score: -79 maxlevel 80 minaction 2 bait 0 mail/h: 2 total 1431 max/h 8 blacklist 0 greylist 0 ratelimit 0 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.91 tagged_above=-10 required=5 tests=BAYES_00=-1.9, T_RP_MATCHES_RCVD=-0.01 X-Spam-Level: X-Archive-Number: 201106/92 X-Sequence-Number: 37718 -----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-----