X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 2F601D1CA50 for ; Mon, 8 Mar 2004 21:46:04 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 27697-08 for ; Mon, 8 Mar 2004 17:46:02 -0400 (AST) Received: from vsmtp1.tin.it (vsmtp1alice.tin.it [212.216.176.141]) by svr1.postgresql.org (Postfix) with ESMTP id 7C1CDD1C9ED for ; Mon, 8 Mar 2004 17:46:00 -0400 (AST) Received: from host20-33.pool8248.interbusiness.it (82.48.33.20) by vsmtp1.tin.it (7.0.019) (authenticated as silvanadimartino) id 4034BCBF0037CA5B; Mon, 8 Mar 2004 22:45:47 +0100 From: Silvana Di Martino To: Bruce Momjian Subject: Re: Article on DB encryption Date: Mon, 8 Mar 2004 22:43:12 +0000 User-Agent: KMail/1.5 Cc: pgsql-admin@postgresql.org References: <200403081919.i28JJNn18271@candle.pha.pa.us> In-Reply-To: <200403081919.i28JJNn18271@candle.pha.pa.us> MIME-Version: 1.0 Content-Disposition: inline Message-Id: <200403082225.12888.silvanadimartino@tin.it> Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200403/137 X-Sequence-Number: 12706 Alle 19:19, luned=EC 8 marzo 2004, Bruce Momjian ha scritto: > The user could decrypt it and store it in a temporary table, and join to > that table in queries, and pass that decrypted password column to > pg_crypto functions, but do we guarantee that that temp table would not > be on the disk if the server crashes and is then stolen? Seems > server-side variables would be a natural, secure use for this that temp > tables don't supply. I agree. This "Global Server Password" should not be stored into a database= ,=20 not even into a temporary table (because of virtual memory). It should be= =20 stored in memory as a server-wide variable. We just need a way to pass it t= o=20 the server at start-up, using a command line parameter, or even to the=20 running server, using a TCP/IP socket or something like that. Most likely,= =20 this second form would better fit the needs of a server. See you PS: Bruce, it's a real pleasure to meet you on the web. Your book on=20 PostgreSQL is one of the most "chewed" of my collection. ----------------------------------------- Alessandro Bottoni and Silvana Di Martino alessandrobottoni@interfree.it silvanadimartino@tin.it