Received: from malur.postgresql.org ([2a02:16a8:dc51::56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1foDmW-0002GA-Ha for pgsql-general@arkaria.postgresql.org; Fri, 10 Aug 2018 20:13:08 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1foDmT-0001oH-QT for pgsql-general@arkaria.postgresql.org; Fri, 10 Aug 2018 20:13:05 +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 1foDmT-0001o0-F2; Fri, 10 Aug 2018 20:13:05 +0000 Received: from mtaout004-public.msg.strl.va.charter.net ([68.114.190.29]) by makus.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1foDmQ-0000zE-IT; Fri, 10 Aug 2018 20:13:04 +0000 Received: from impout006 ([68.114.189.21]) by mtaout004.msg.strl.va.charter.net (InterMail vM.9.00.023.01 201-2473-194) with ESMTP id <20180810201301.ENCZ3685.mtaout004.msg.strl.va.charter.net@impout006>; Fri, 10 Aug 2018 15:13:01 -0500 Received: from cerberus.crazybean.net ([24.151.10.150]) by impout006 with charter.net id MYCz1y00G3EE3TL01YD0s7; Fri, 10 Aug 2018 15:13:01 -0500 X-Authority-Analysis: v=2.2 cv=UeshcOaN c=1 sm=1 tr=0 a=D2HTw/M6/8MmcHighGO7rg==:117 a=D2HTw/M6/8MmcHighGO7rg==:17 a=xqWC_Br6kY4A:10 a=dapMudl6Dx4A:10 a=PZ4f35sIAAAA:8 a=mhDCfZOgM3OJ3owRvmIA:9 a=QEXdDO2ut3YA:10 a=WYcstXRTpSpsG8FJN-kA:9 a=GoEzpzOMl6zog6z-:21 a=_W_S_7VecoQA:10 a=LA1rVF_fkLT6rIHShkKf:22 Received: from [IPv6:2001:470:e117:4:c13f:ef6e:e3bc:25db] (2001:470:e117:4:c13f:ef6e:e3bc:25db [IPv6:2001:470:e117:4:c13f:ef6e:e3bc:25db]) by cerberus.crazybean.net (OpenSMTPD) with ESMTPSA id c67c8e01 (TLSv1.2:ECDHE-RSA-AES256-GCM-SHA384:256:NO); Fri, 10 Aug 2018 16:12:59 -0400 (EDT) From: Rui DeSousa Message-Id: Content-Type: multipart/alternative; boundary="Apple-Mail=_BDBC509A-D099-4A4C-BD2B-BB632E0C0661" Mime-Version: 1.0 (Mac OS X Mail 12.0 \(3445.100.24\)) Subject: Re: How to revoke privileged from PostgreSQL's superuser Date: Fri, 10 Aug 2018 16:12:58 -0400 In-Reply-To: Cc: Evan Bauer , bejita0409@yahoo.co.jp, "pgsql-admin@lists.postgresql.org" , "pgsql-general@lists.postgresql.org" To: Bear Giles References: <913907.28546.qm@web103014.mail.kks.yahoo.co.jp> <26930.1533562986@sss.pgh.pa.us> X-Mailer: Apple Mail (2.3445.100.24) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --Apple-Mail=_BDBC509A-D099-4A4C-BD2B-BB632E0C0661 Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset=utf-8 > On Aug 6, 2018, at 10:45 AM, Bear Giles wrote: >=20 > then it's reasonable to ask if storing the information in a relational = database is the best approach. Why? Just because its encrypted doesn=E2=80=99t mean it shouldn=E2=80=99t = be stored in the database. What about PITR, how would that be handled? = You basically would have to reimplement things the RDBMS system gives = you for free by storing it outside the database. Don=E2=80=99t forget = it's called a management system for a reason.= --Apple-Mail=_BDBC509A-D099-4A4C-BD2B-BB632E0C0661 Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset=utf-8

On Aug 6, 2018, at 10:45 AM, Bear Giles <bgiles@coyotesong.com> wrote:

then it's = reasonable to ask if storing the information in a relational database is = the best approach.

Why? Just because its encrypted doesn=E2=80=99t mean it = shouldn=E2=80=99t be stored in the database. What about PITR, how would = that be handled?  You basically would have to reimplement things = the RDBMS system gives you for free by storing it outside the database. =  Don=E2=80=99t forget it's called a management system for a = reason.
= --Apple-Mail=_BDBC509A-D099-4A4C-BD2B-BB632E0C0661--