Date: Mon, 9 Jun 2014 18:08:21 -0400 From: Dan Langille <dan@langille.org> To: freebsd-ports@freebsd.org Cc: pgsql@FreeBSD.org Subject: databases/postgresql92-server does not honor uid/gid Message-ID: <AB0C1ADE-4680-4FA4-B0C3-AE78427E3DD4@langille.org>
next in thread | raw e-mail | index | archive | help
--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--
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?AB0C1ADE-4680-4FA4-B0C3-AE78427E3DD4>