From owner-freebsd-ports@FreeBSD.ORG Tue Jun 10 07:20:55 2014 Return-Path: Delivered-To: freebsd-ports@freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [8.8.178.115]) (using TLSv1 with cipher ADH-AES256-SHA (256/256 bits)) (No client certificate requested) by hub.freebsd.org (Postfix) with ESMTPS id 9F0F12BD; Tue, 10 Jun 2014 07:20:55 +0000 (UTC) Received: from mk-outboundfilter-5.mail.uk.tiscali.com (mk-outboundfilter-5.mail.uk.tiscali.com [212.74.114.1]) by mx1.freebsd.org (Postfix) with ESMTP id E87E3233F; Tue, 10 Jun 2014 07:20:53 +0000 (UTC) X-Trace: 111845209/mk-outboundfilter-5.mail.uk.tiscali.com/PIPEX/$ON_NET_AUTH_ACCEPTED/pipex-temporary-group/81.170.77.156/None/crees@physics.org X-SBRS: None X-RemoteIP: 81.170.77.156 X-IP-MAIL-FROM: crees@physics.org X-SMTP-AUTH: bayofrum@uwclub.net X-MUA: K-9 Mail for Android X-IP-BHB: Once X-IronPort-Anti-Spam-Filtered: true X-IronPort-Anti-Spam-Result: Au8bAPiwllNRqk2c/2dsb2JhbABZgw1Sg0WnewEBAQEBAQaZCwMCAYELF3WEAwEBAQQjDwEjIxALBBQqAgI5HgYBDQWIQgSrI589F4VdhA2EMQEBDUIHCYJsgUwBA5ohhl8XjE+DPYFuBxc X-IPAS-Result: Au8bAPiwllNRqk2c/2dsb2JhbABZgw1Sg0WnewEBAQEBAQaZCwMCAYELF3WEAwEBAQQjDwEjIxALBBQqAgI5HgYBDQWIQgSrI589F4VdhA2EMQEBDUIHCYJsgUwBA5ohhl8XjE+DPYFuBxc X-IronPort-AV: E=Sophos;i="4.98,1007,1392163200"; d="scan'208,217";a="111845209" X-IP-Direction: OUT Received: from 81-170-77-156.dynamic.dsl.as9105.com (HELO pegasus.bayofrum.net) ([81.170.77.156]) by smtp.pipex.tiscali.co.uk with ESMTP; 10 Jun 2014 08:19:43 +0100 Received: from [10.195.93.24] (unknown [149.254.181.67]) by pegasus.bayofrum.net (Postfix) with ESMTPSA id 4294B5F12A; Tue, 10 Jun 2014 08:19:31 +0100 (BST) User-Agent: K-9 Mail for Android In-Reply-To: References: MIME-Version: 1.0 Subject: Re: databases/postgresql92-server does not honor uid/gid From: Chris Rees Date: Tue, 10 Jun 2014 08:19:19 +0100 To: Dan Langille ,freebsd-ports@freebsd.org Message-ID: <9df8be4a-a372-4405-b4b9-5750d9a6b0e8@email.android.com> X-bayofrum-MailScanner-Information: Please contact the ISP for more information X-bayofrum-MailScanner-ID: 4294B5F12A.AFF55 X-bayofrum-MailScanner: Found to be clean X-bayofrum-MailScanner-From: crees@physics.org X-Spam-Status: No Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 8bit X-Content-Filtered-By: Mailman/MimeDel 2.1.18 Cc: pgsql@FreeBSD.org X-BeenThere: freebsd-ports@freebsd.org X-Mailman-Version: 2.1.18 Precedence: list List-Id: Porting software to FreeBSD List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Tue, 10 Jun 2014 07:20:55 -0000 This is a general problem with the USERS framework. I think I may have a PR in.. Chris On 9 June 2014 23:08:21 BST, Dan Langille wrote: >FYI: > >I upgraded databases/postgresql92-server a system today. Afterwards, I >encountered this situation: > >$ sudo /usr/local/etc/rc.d/postgresql initdb >The files belonging to this database system will be owned by user >"pgsql". >This user must also own the server process. > >The database cluster will be initialized with locale "C". >The default database encoding has accordingly been set to "SQL_ASCII". >The default text search configuration will be set to "english". > >creating directory /usr/local/pgsql/data ... initdb: could not create >directory "/usr/local/pgsql/data": Permission denied > > > >Oh… ummmm… > >$ ls -ld /usr/local/pgsql >drwxr-xr-x 2 70 70 6 Jun 9 21:03 /usr/local/pgsql > >eh? > >$ id pgsql >uid=10837(pgsql) gid=10837(pgsql) groups=10837(pgsql) > >On this system, a jail. the uid/gid for pgsql are not standard. > >I solved the problem with: $ sudo chown pgsql:pgsql /usr/local/pgsql/ > > >— >Dan Langille -- Sent from my Android device with K-9 Mail. Please excuse my brevity. -- This message has been scanned for viruses and dangerous content by MailScanner, and is believed to be clean.