Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1eqOmh-00079l-9Q for pgsql-admin@arkaria.postgresql.org; Mon, 26 Feb 2018 19:50:03 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1eqOmf-0002k3-Ri for pgsql-admin@arkaria.postgresql.org; Mon, 26 Feb 2018 19:50:01 +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.89) (envelope-from ) id 1eqOmf-0002jt-9V for pgsql-admin@lists.postgresql.org; Mon, 26 Feb 2018 19:50:01 +0000 Received: from adriana.opensysperu.com ([158.69.30.115]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1eqOmb-0006Zd-Uj for pgsql-admin@postgresql.org; Mon, 26 Feb 2018 19:49:59 +0000 Received: from localhost (localhost [IPv6:::1]) by adriana.opensysperu.com (Postfix) with ESMTP id 579A9E155B; Mon, 26 Feb 2018 14:50:10 -0500 (-05) Received: from adriana.opensysperu.com ([IPv6:::1]) by localhost (adriana.opensysperu.com [IPv6:::1]) (amavisd-new, port 10032) with ESMTP id vlwQ8iQkdNCU; Mon, 26 Feb 2018 14:50:09 -0500 (-05) Received: from localhost (localhost [IPv6:::1]) by adriana.opensysperu.com (Postfix) with ESMTP id 0F93BE155E; Mon, 26 Feb 2018 14:50:09 -0500 (-05) X-Virus-Scanned: amavisd-new at opensysperu.com Received: from adriana.opensysperu.com ([IPv6:::1]) by localhost (adriana.opensysperu.com [IPv6:::1]) (amavisd-new, port 10026) with ESMTP id CryUzrQizSxl; Mon, 26 Feb 2018 14:50:08 -0500 (-05) Received: from adriana.opensysperu.com (adriana.opensysperu.com [158.69.30.115]) by adriana.opensysperu.com (Postfix) with ESMTP id E8DABE155D; Mon, 26 Feb 2018 14:50:08 -0500 (-05) Date: Mon, 26 Feb 2018 14:50:08 -0500 (PET) From: Alvaro Aguayo Garcia-Rada To: David Cc: pgsql-admin Message-ID: <549154170.161328.1519674608867.JavaMail.zimbra@opensysperu.com> In-Reply-To: References: Subject: Re: Is it okay to run Postgres service account as a domain account (on Linux)? MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit X-Originating-IP: [172.18.5.200] X-Mailer: Zimbra 8.6.0_GA_1153 (ZimbraWebClient - GC64 (Linux)/8.6.0_GA_1153) Thread-Topic: Is it okay to run Postgres service account as a domain account (on Linux)? Thread-Index: feN0pO7zQSO3oCg7PH1sQIlefqPd5A== List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk Even when possible, I won't recommend it; not for postgres reasons, but for security. If someone compromises the domain account, could gain access to postgres data with no restriction. Unless there is a reason to use a domain account, of source. Saludos, Alvaro Aguayo Jefe de Operaciones Open Comb Systems E.I.R.L. Oficina: (+51-1) 3377813 | Cel.: (+51) 995540103 | RPC: (+51) 954183248 Website: www.ocs.pe ----- Original Message ----- From: "David" To: "pgsql-admin" Sent: Monday, 26 February, 2018 11:22:34 Subject: Is it okay to run Postgres service account as a domain account (on Linux)? Just wondering if it is recommended, or not, to run Postgres as a domain account on Linux. If not, then why not? Thank you, David