pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Silvana Di Martino <silvanadimartino@tin.it>
To: Bruce Momjian <pgman@candle.pha.pa.us>
Cc: pgsql-admin@postgresql.org
Subject: Re: Article on DB encryption
Date: Mon, 8 Mar 2004 22:43:12 +0000
Message-ID: <200403082225.12888.silvanadimartino@tin.it> (raw)
In-Reply-To: <200403081919.i28JJNn18271@candle.pha.pa.us>
References: <200403081919.i28JJNn18271@candle.pha.pa.us>

Alle 19:19, lunedì 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, 
not even into a temporary table (because of virtual memory). It should be 
stored in memory as a server-wide variable. We just need a way to pass it to 
the server at start-up, using a command line parameter, or even to the 
running server, using a TCP/IP socket or something like that. Most likely, 
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 
PostgreSQL is one of the most "chewed" of my collection.

-----------------------------------------
Alessandro Bottoni and Silvana Di Martino
alessandrobottoni@interfree.it
silvanadimartino@tin.it



view thread (3+ messages)

Message-ID: <200403082225.12888.silvanadimartino@tin.it>
Permalink:  ../200403082225.12888.silvanadimartino@tin.it/
Also on:    postgresql.org/message-id/200403082225.12888.silvanadimartino@tin.it

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-admin@postgresql.org
  Cc: silvanadimartino@tin.it, pgman@candle.pha.pa.us
  Subject: Re: Article on DB encryption
  In-Reply-To: <200403082225.12888.silvanadimartino@tin.it>
  References: <200403081919.i28JJNn18271@candle.pha.pa.us> <200403082225.12888.silvanadimartino@tin.it>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox