Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1bPmfc-0005jU-Qb for pgsql-admin@arkaria.postgresql.org; Wed, 20 Jul 2016 08:15:57 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1bPmfc-0000r4-59 for pgsql-admin@arkaria.postgresql.org; Wed, 20 Jul 2016 08:15:56 +0000 Received: from makus.postgresql.org ([2001:4800:1501:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1bPmfa-0000qx-FR for pgsql-admin@postgresql.org; Wed, 20 Jul 2016 08:15:55 +0000 Received: from nm50.bullet.mail.gq1.yahoo.com ([67.195.87.86]) by makus.postgresql.org with esmtps (TLS1.0:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.84_2) (envelope-from ) id 1bPmfW-0005nw-Vf for pgsql-admin@postgresql.org; Wed, 20 Jul 2016 08:15:53 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.de; s=s2048; t=1469002548; bh=FYDR+vb/4JDU6ePYx5Ik1w0J/AB+Y6kqlZwxii3LlGU=; h=Date:From:Reply-To:To:Cc:In-Reply-To:References:Subject:From:Subject; b=EzHFh3ryU7cqo6g7HaUolRH5NU37bc3OK8uVesb2h9Mj3fuCFBcn8zsEnGJR2SzDgi2GdPGc/FKp1itZuIdcfcXiK1oNbgFVZJvnz+oFecaB1ORgYCwz0zszWzj1G5HaSME9k9ugwRToMnE/+9Th0KJmM0UVEKgGK6ZjZuD4+BVds37585zvnrJlWsa/RbgHnkE7oxM784FvZFDOLFD243EBj6b0gzgkWPL+0yFSF8pDJw3eKc01/6FH3+hxf/0S5/tb4Y7LemQ3YfxGeC6DCIERFpGVUr6WH3+Uoqx7Lpk5VdkwFGT20T6Jc9zVa1jcAipFyFf2BJQljws+gBZTJA== Received: from [127.0.0.1] by nm50.bullet.mail.gq1.yahoo.com with NNFMP; 20 Jul 2016 08:15:48 -0000 Received: from [98.137.12.62] by nm50.bullet.mail.gq1.yahoo.com with NNFMP; 20 Jul 2016 08:12:54 -0000 Received: from [212.82.98.126] by tm7.bullet.mail.gq1.yahoo.com with NNFMP; 20 Jul 2016 08:12:54 -0000 Received: from [212.82.98.74] by tm19.bullet.mail.ir2.yahoo.com with NNFMP; 20 Jul 2016 08:12:53 -0000 Received: from [127.0.0.1] by omp1011.mail.ir2.yahoo.com with NNFMP; 20 Jul 2016 08:12:53 -0000 X-Yahoo-Newman-Property: ymail-4 X-Yahoo-Newman-Id: 747471.25080.bm@omp1011.mail.ir2.yahoo.com X-YMail-OSG: hNNyPjAVM1kgtjUbL9XeUo3zSl9ysU761msdLCI8S1htBuRXf2I4JFBS7K94csx PaxSQPgMVhJ.jzTqQZD9Sc2VsEU_2.QHLG_ODJg5xoPHxesnEWO31rlLne_sM64t9yoUCG0Zea7P bvItcnHzd5Q2hnnF1mBgFhJ6b0erI9Yzosy5gSSTPGBAl95.ZuGPLcUiUq7mTqA6TjtUT0ZcSgIX 1B7cafLMpnrd1UFjDwI5g53RfMDRwli1W39dRZS8y6t9pH4gqcPRcGDdL.hxZ_jmJef4BW4cYMA1 7iYj9F9pE6xUoKeXNCnqK9E1vkcCtCJT27sUNnNJ0XCU.q9xsNOnenlbQY35AWn1wBmqoyykth4D 6IQzq6zFHz2BCzq3_Rq5hPIQyzci485v6sWTgXz47cG7Nbt3qdTJ2K0LceXZE3rQ3HO.h1eOlHiS zfpN4Q_dHKABO2L0mk0IVfcWX_pkasVLCa2NuYJnbXFn5XE1sBYVPIhah98yEjN1Z5Z3xVTgJIwO stcqjYO7F7._V0r7KrpsDvpKv6.wVCecqQm56p3leRxjEAE0ptsG.WktmMVz8.8P2UTv73cvn1a4 JTaqTnNuwJA-- Received: from jws11103.mail.ir2.yahoo.com by sendmailws104.mail.ir2.yahoo.com; Wed, 20 Jul 2016 08:12:53 +0000; 1469002373.317 Date: Wed, 20 Jul 2016 08:12:53 +0000 (UTC) From: Wolfgang Wilhelm Reply-To: Wolfgang Wilhelm To: "David G. Johnston" , "Maki Smith (US - IFS)" Cc: "pgsql-admin@postgresql.org" Message-ID: <1964189799.3313708.1469002373028.JavaMail.yahoo@mail.yahoo.com> In-Reply-To: References: Subject: Re: running postgresql with a different id other than postgres user MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_3313707_1907503450.1469002373021" Content-Length: 5657 X-Pg-Spam-Score: -2.2 (--) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-admin Precedence: bulk Sender: pgsql-admin-owner@postgresql.org ------=_Part_3313707_1907503450.1469002373021 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Hello, a little more information would be helpful.But to make things short: The us= er who starts the initdb command is the database admin user. When you insta= ll PostgreSQL via the tool of your distribution like apt (Debian), yum or w= hatever then the package manager generates the user postgres and executes i= nitdb as user postgres. Kind regards,Wolfgang =20 David G. Johnston schrieb am 21:34 Diensta= g, 19.Juli 2016: =20 On Tue, Jul 19, 2016 at 3:16 PM, Maki Smith (US - IFS) wrote: To meet our security requirement, we would like to use another account othe= r than postgres to install and run postgreSQL.=C2=A0 Is this possible to do= ? =E2=80=8BYou need to tell us by what method you intend to install PostgreSQ= L, and on what platform, before this can be usefully answered.=E2=80=8B The documentation covers how to go about installing from source.=C2=A0 It s= hould cover how to choose a label different than "postgres" if you so desir= e. David J. ------=_Part_3313707_1907503450.1469002373021 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable
Hello,

a little m= ore information would be helpful.
But to make things short: The user who starts the= initdb command is the database admin user. When you install PostgreSQL via= the tool of your distribution like apt (Debian), yum or whatever then the = package manager generates the user postgres and executes initdb as user pos= tgres.
<= br>
Kind= regards,
Wolfgang




David G. Johnston <david.g.johnston@gmail.co= m> schrieb am 21:34 Dienstag, 19.Juli 2016:


<= div class=3D"y_msg_container">
On Tue, = Jul 19, 2016 at 3:16 PM, Maki Smith (US - IFS) <maki.smith@pwc.com> wrote:
To meet our secur= ity requirement, we would like to use another account other than postgres t= o install and run postgreSQL.  Is this possible to do?


<= div class=3D"yiv5964737006gmail_default" style=3D"font-family:arial, helvet= ica, sans-serif;display:inline;">=E2=80=8BYou need to tell us by what metho= d you intend to install PostgreSQL, and on what platform, before this can b= e usefully answered.=E2=80=8B

= The documentation covers how to go about installing from source.  It s= hould cover how to choose a label different than "postgres" if you so desir= e.

David J.



------=_Part_3313707_1907503450.1469002373021--