From mboxrd@z Thu Jan 1 00:00:00 1970 Received: from pigeon.gentoo.org ([208.92.234.80] helo=lists.gentoo.org) by finch.gentoo.org with esmtp (Exim 4.60) (envelope-from ) id 1SMgII-00052i-3V for garchives@archives.gentoo.org; Tue, 24 Apr 2012 14:00:38 +0000 Received: from pigeon.gentoo.org (localhost [127.0.0.1]) by pigeon.gentoo.org (Postfix) with SMTP id D76BEE0B53; Tue, 24 Apr 2012 14:00:18 +0000 (UTC) Received: from mail2.viabit.com (mail2.viabit.com [65.246.80.16]) by pigeon.gentoo.org (Postfix) with ESMTP id 61E50E09EE for ; Tue, 24 Apr 2012 13:58:39 +0000 (UTC) Received: from [10.1.1.204] (unknown [65.213.236.244]) (using TLSv1 with cipher ECDHE-RSA-AES256-SHA (256/256 bits)) (No client certificate requested) by mail2.viabit.com (Postfix) with ESMTPSA id AD97E37B2E for ; Tue, 24 Apr 2012 09:58:38 -0400 (EDT) DKIM-Signature: v=1; a=rsa-sha256; c=simple/simple; d=orlitzky.com; s=mail2; t=1335275918; bh=ty2ZbpHgjNxNKi4I9aMQx0MVjgfXQkOLyxYDAjGsGL0=; h=Message-ID:Date:From:MIME-Version:To:Subject:References: In-Reply-To:Content-Type:Content-Transfer-Encoding; b=vDoIDVFpXFD+Ul+NIm7q2kJskfAj4mWFqLnMNgkCMo4H1OQ9KliKq+srrSiDqjvU3 uccCE0FS2ItFCEOTxcbyOYsh7iWu5398TWOs19K8zzzhqZhk+nN852NCTeUCDi0pT5 owgrSWkbay4gRcqBlDvfoRWJhrw1mqc7OTYT91QI= Message-ID: <4F96B18E.4060000@orlitzky.com> Date: Tue, 24 Apr 2012 09:58:38 -0400 From: Michael Orlitzky User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:10.0.3) Gecko/20120423 Thunderbird/10.0.3 Precedence: bulk List-Post: List-Help: List-Unsubscribe: List-Subscribe: List-Id: Gentoo Linux mail X-BeenThere: gentoo-user@lists.gentoo.org Reply-to: gentoo-user@lists.gentoo.org MIME-Version: 1.0 To: gentoo-user@lists.gentoo.org Subject: Re: [gentoo-user] Postgres suddenly can't access files in its /etc directory References: <20120423132130.GA11404@squareownz.org> <4F956A86.8060105@orlitzky.com> <20120423154432.GA29725@squareownz.org> <4F957BBF.5080909@orlitzky.com> <20120423211815.GA7699@squareownz.org> <87obqhwvgl.fsf@newton.gmurray.org.uk> <20120424093136.GA19474@squareownz.org> In-Reply-To: <20120424093136.GA19474@squareownz.org> Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit X-Archives-Salt: a715be09-6471-4624-812f-042380953680 X-Archives-Hash: 993f1ab7363cadd654c7e919ef0be47b On 04/24/12 05:31, napalm@squareownz.org wrote: > On Tue, Apr 24, 2012 at 06:27:22AM +0100, Graham Murray wrote: >> napalm@squareownz.org writes: >> >>> Postgres doesn't have a home directory and if I create one and chown it >>> postgres:postgres I still can't do anything. I'm totally at a loss here. >> >> Postgres should have a home directory - /var/lib/postgresql >> >> If you run su - postgres, this is the directory you should be in. >> > Ah okay, I've changed it back to this then. I do indeed enter there now. > I've emerged it without threads or pam as I suspected it may have been > either of them but that hasn't seemed to solve much of anything. > > The current error I'm getting is: > # /etc/init.d/postgresql-9.1 start > * Starting PostgreSQL ... > * start-stop-daemon: did not create a valid pid in > * `/var/lib/postgresql/9.1/data/postmaster.pid' > * Check the PostgreSQL 9.1 log for a detailed explanation of the > * above error. [ !! ] > > Which is what happens when start-stop-daemon fails to execute its > command. I'm not entirely sure what start-stop-daemon is or what > permissions it may need or be missing so I'm about to look into that. > Is everything under (and including) /var/lib/postgresql owned by postgres:postgres? ~ # ls /var/lib/postgresql/9.1 total 4.0K drwx------ 13 postgres postgres 4.0K 2012-04-23 18:58 data ~ # ls /var/lib/postgresql/9.1/data/ total 1.2M -rw------- 1 postgres postgres 4 2012-02-14 00:14 PG_VERSION drwx------ 7 postgres postgres 4.0K 2012-04-23 10:31 base drwx------ 2 postgres postgres 4.0K 2012-04-23 18:59 global drwx------ 2 postgres postgres 4.0K 2012-02-14 00:14 pg_clog drwx------ 4 postgres postgres 4.0K 2012-02-14 00:14 pg_multixact drwx------ 2 postgres postgres 4.0K 2012-04-23 18:58 pg_notify drwx------ 2 postgres postgres 4.0K 2012-02-14 00:14 pg_serial drwx------ 2 postgres postgres 4.0K 2012-04-24 09:57 pg_stat_tmp drwx------ 2 postgres postgres 4.0K 2012-04-20 13:42 pg_subtrans drwx------ 2 postgres postgres 4.0K 2012-02-14 00:14 pg_tblspc drwx------ 2 postgres postgres 4.0K 2012-02-14 00:14 pg_twophase drwx------ 3 postgres postgres 4.0K 2012-04-23 11:36 pg_xlog -rw------- 1 postgres postgres 1.1M 2012-04-24 09:55 postmaster.log -rw------- 1 postgres postgres 134 2012-04-23 18:58 postmaster.opts -rw------- 1 postgres postgres 92 2012-04-23 18:58 postmaster.pid