Postgres security issue - protecting datafiles - Mailing list pgsql-admin

From zferentz@gmail.com
Subject Postgres security issue - protecting datafiles
Date
Msg-id ce1722a1-ab34-4915-b5db-1915c0dfa5b0@f63g2000hsf.googlegroups.com
Whole thread Raw
Responses Re: Postgres security issue - protecting datafiles  ("Jonah H. Harris" <jonah.harris@gmail.com>)
Re: Postgres security issue - protecting datafiles  (Tino Schwarze <postgresql@tisc.de>)
Re: Postgres security issue - protecting datafiles  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-admin
Hi,
I'd like to use postgres to store my secret data  in a way that only
me (the DBA, owner of the table) can access the talbe while the root
(system administrator) who installed and maintains the server - will
not be able to see the data.

Now, I think that "db authentication"  is simply not enough , because
the administrator can copy the data files to his own machine (where he
is the owner of the database).

Is there a way to protect the data files, so even the "malicious
administrator" cannot see the data ?

tnx,
zferentz

pgsql-admin by date:

Previous
From: Tom Lane
Date:
Subject: Re: Create Index Performance Issue
Next
From: "Jonah H. Harris"
Date:
Subject: Re: Postgres security issue - protecting datafiles