Date: Tue, 10 Jun 2014 08:19:19 +0100 From: Chris Rees <crees@physics.org> To: Dan Langille <dan@langille.org>,freebsd-ports@freebsd.org Cc: pgsql@FreeBSD.org Subject: Re: databases/postgresql92-server does not honor uid/gid Message-ID: <9df8be4a-a372-4405-b4b9-5750d9a6b0e8@email.android.com> In-Reply-To: <AB0C1ADE-4680-4FA4-B0C3-AE78427E3DD4@langille.org> References: <AB0C1ADE-4680-4FA4-B0C3-AE78427E3DD4@langille.org>
next in thread | previous in thread | raw e-mail | index | archive | help
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 <dan@langille.org> 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.
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?9df8be4a-a372-4405-b4b9-5750d9a6b0e8>