From owner-freebsd-ports@FreeBSD.ORG Mon Jun 9 22:08:31 2014 Return-Path: Delivered-To: freebsd-ports@freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:1900:2254:206a::19:1]) (using TLSv1 with cipher ADH-AES256-SHA (256/256 bits)) (No client certificate requested) by hub.freebsd.org (Postfix) with ESMTPS id 16AA3D61; Mon, 9 Jun 2014 22:08:31 +0000 (UTC) Received: from nyi.unixathome.org (nyi.unixathome.org [64.147.113.42]) (using TLSv1 with cipher DHE-RSA-CAMELLIA256-SHA (256/256 bits)) (Client CN "nyi.unixathome.org", Issuer "StartCom Class 2 Primary Intermediate Server CA" (verified OK)) by mx1.freebsd.org (Postfix) with ESMTPS id DBFE4278F; Mon, 9 Jun 2014 22:08:30 +0000 (UTC) Received: from nyi.unixathome.org (localhost [127.0.0.1]) by nyi.unixathome.org (Postfix) with ESMTP id 778465089F; Mon, 9 Jun 2014 22:08:22 +0000 (UTC) X-Virus-Scanned: amavisd-new at unixathome.org Received: from nyi.unixathome.org ([127.0.0.1]) by nyi.unixathome.org (nyi.unixathome.org [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 7FLjbU7XNoYD; Mon, 9 Jun 2014 22:08:22 +0000 (UTC) Received: from smtp-auth.unixathome.org (smtp-auth.unixathome.org [10.4.7.7]) (Authenticated sender: hidden) by nyi.unixathome.org (Postfix) with ESMTPSA id E745A50893 ; Mon, 9 Jun 2014 22:08:21 +0000 (UTC) From: Dan Langille Content-Type: multipart/signed; boundary="Apple-Mail=_C22FF793-FB3B-4496-B75A-AC23369398E4"; protocol="application/pgp-signature"; micalg=pgp-sha1 Subject: databases/postgresql92-server does not honor uid/gid Date: Mon, 9 Jun 2014 18:08:21 -0400 Message-Id: To: freebsd-ports@freebsd.org Mime-Version: 1.0 (Mac OS X Mail 7.3 \(1878.2\)) X-Mailer: Apple Mail (2.1878.2) 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: Mon, 09 Jun 2014 22:08:31 -0000 --Apple-Mail=_C22FF793-FB3B-4496-B75A-AC23369398E4 Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset=windows-1252 FYI: I upgraded databases/postgresql92-server a system today. Afterwards, I = encountered this situation: $ sudo /usr/local/etc/rc.d/postgresql initdb=20 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=85 ummmm=85 $ ls -ld /usr/local/pgsql drwxr-xr-x 2 70 70 6 Jun 9 21:03 /usr/local/pgsql eh? $ id pgsql uid=3D10837(pgsql) gid=3D10837(pgsql) groups=3D10837(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/ =97=20 Dan Langille --Apple-Mail=_C22FF793-FB3B-4496-B75A-AC23369398E4 Content-Transfer-Encoding: 7bit Content-Disposition: attachment; filename=signature.asc Content-Type: application/pgp-signature; name=signature.asc Content-Description: Message signed with OpenPGP using GPGMail -----BEGIN PGP SIGNATURE----- Comment: GPGTools - http://gpgtools.org iEYEARECAAYFAlOWMFUACgkQCgsXFM/7nTyXNACghfhCpMpd4UyNBzvrpFwV3Hnv sNUAoPX/2t5dYzNHNQHD6hpPGQYNWaul =FSAF -----END PGP SIGNATURE----- --Apple-Mail=_C22FF793-FB3B-4496-B75A-AC23369398E4--