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 BA321D1D301 for ; Fri, 5 Mar 2004 20:17:20 +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 60745-04 for ; Fri, 5 Mar 2004 16:17:18 -0400 (AST) Received: from vsmtp3.tin.it (vsmtp3alice.tin.it [212.216.176.143]) by svr1.postgresql.org (Postfix) with ESMTP id 67AB3D1D306 for ; Fri, 5 Mar 2004 16:17:16 -0400 (AST) Received: from host181-31.pool80116.interbusiness.it (80.116.31.181) by vsmtp3.tin.it (7.0.019) (authenticated as silvanadimartino) id 402CD18F00420238; Fri, 5 Mar 2004 21:17:14 +0100 From: Silvana Di Martino To: Mark Gibson , pgsql-admin@postgresql.org Subject: Re: Database Encryption (now required by law in Italy) Date: Fri, 5 Mar 2004 21:18:37 +0000 User-Agent: KMail/1.5 References: <200403050951.33230.silvanadimartino@tin.it> <40488663.7040108@cromwell.co.uk> In-Reply-To: <40488663.7040108@cromwell.co.uk> MIME-Version: 1.0 Content-Disposition: inline Message-Id: <200403052102.40518.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/65 X-Sequence-Number: 12635 Alle 13:53, venerd=EC 5 marzo 2004, Mark Gibson ha scritto: > Silvana Di Martino wrote: > >Is there any (native/third party) tool for encrypting a PGSQL database on > > the disk? Is there any PGSQL option for encrypting data on the fly? > > Have a look in contrib/pgcrypto. > Although I haven't actually tried it yet. Thanks! The pgcrypto package contains a few server-side (C + PL/PGSQL) functions th= at=20 implement a few data encryption/decryption methods. It looks like they can = be=20 used to protect my data from unauthorized access. See you ----------------------------------------- Alessandro Bottoni and Silvana Di Martino alessandrobottoni@interfree.it silvanadimartino@tin.it