Received: from localhost (unknown [200.46.204.184]) by developer.postgresql.org (Postfix) with ESMTP id 8D8F12E0032 for ; Tue, 29 Apr 2008 15:53:55 -0300 (ADT) Received: from developer.postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 89918-01 for ; Tue, 29 Apr 2008 15:53:49 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.5 Received: from qb-out-0506.google.com (qb-out-0506.google.com [72.14.204.237]) by developer.postgresql.org (Postfix) with ESMTP id 7C2202E004C for ; Tue, 29 Apr 2008 15:53:50 -0300 (ADT) Received: by qb-out-0506.google.com with SMTP id o12so43954qba.17 for ; Tue, 29 Apr 2008 11:53:49 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; bh=mhr1VxL5PF6gV7yaAGYOUW/qq/+FJOX33keTMFv9iTo=; b=f8Uxo12w9BqwXziZniGf5Oj+aDI3JH1E0oI64M49Ta7SB/glsWTkhkOpnjmnnbmvt8xJBdzEk2YSowp4sXQlZAZNOA/5CdmeAdH1anhlbtNC1RWEKtCCaOAKDm8H4rzcoT8/vyJIvtq+AZvbwq9pFzTfYY0TCCo52CDGRdIElIk= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=AHmrRlLPwyMrxraKZajfQH2ogQwd+3onoyWdurIxfC8lRc6LIbc2xUdH5a/XIPq+mMurV09zgDomorGS/UiJrHKbi6r/vDCm3XbvHRC26+pzbPHCfVbZRvlILRg7OPgapIyzuM33aFEop5twNfRfdNHFs+Axa8W0zVCldXc0chY= Received: by 10.115.22.14 with SMTP id z14mr8383259wai.138.1209495229413; Tue, 29 Apr 2008 11:53:49 -0700 (PDT) Received: by 10.114.137.7 with HTTP; Tue, 29 Apr 2008 11:53:49 -0700 (PDT) Message-ID: Date: Tue, 29 Apr 2008 12:53:49 -0600 From: "Scott Marlowe" To: "e t" Subject: Re: server crash, need to restore DB functionality Cc: pgsql-admin@postgresql.org In-Reply-To: <82d6a2d00804291018h3f05bbe3gb21cae15eb7a0643@mail.gmail.com> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline References: <82d6a2d00804291018h3f05bbe3gb21cae15eb7a0643@mail.gmail.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200804/286 X-Sequence-Number: 29050 On Tue, Apr 29, 2008 at 11:18 AM, e t wrote: > Apr 29 13:15:34 cp postgres[4961]: [107-1] ERROR: could not open relation > "users_pkey": Permission denied Wait, permission denied? Sounds like the network monkeys in your NOC are doing things they should not be doing, like changing permissions. Try changing the perms of all the stuff under the pgdata directory to the pg user (usually postgres on RHEL) and see if that helps.