Re: [ADMIN] Database level encryption

2010-04-07 Thread Timothy Madden
Ok people thank you for your answers. Timothy Madden On Wed, Apr 7, 2010 at 3:25 PM, Michael Gould wrote: > Timothy, > > I've worked with SQL Anywhere which does have database encryption.  There > are pluses to having a encrypted db, but it did slow down the processing. &g

Re: [ADMIN] Database level encryption

2010-04-07 Thread Timothy Madden
On Wed, Apr 7, 2010 at 1:07 AM, Kevin Grittner wrote: > Timothy Madden wrote: > [...] > But the server needs to read certain data from the database > directory in order to start.  In particular, WAL files need to be > read to get a clean start, and those can contain any data from

Re: [ADMIN] Database level encryption

2010-04-07 Thread Timothy Madden
ss to your machine, nothing (no filesystem > and no database encryption) is goint to help you here. I would have to disagree with you here. The whole point of encryption is that you need the key in order to get your data back. Timothy Madden -- Sent via pgsql-admin mailing list (pgsql-a

Re: [ADMIN] Database level encryption

2010-04-06 Thread Timothy Madden
columns in all tables are ecrypted (although I would like even the number and names of tables and schema-objects to be encrypted). On Tue, Apr 6, 2010 at 5:36 PM, Kevin Grittner wrote: > Timothy Madden wrote: > >> With an encrypted database, you need the password anytime you >>

Re: [ADMIN] Database level encryption

2010-04-06 Thread Timothy Madden
ote: >> Scott Marlowe wrote: >>> Timothy Madden wrote: >> >>>> My scenario is how to protect the database if the machine is >>>> stolen (it is a mini-laptop), and I would like to encrypt the >>>> entire database, that is all columns of all tables

Re: [ADMIN] Database level encryption

2010-04-05 Thread Timothy Madden
database-level encryption. Thank you, Timothy Madden On Sat, Apr 3, 2010 at 8:03 PM, Joe Conway wrote: > On 04/03/2010 06:35 AM, Timothy Madden wrote: >> I can only see how PostgreSQL encrypts the password or the connection >> in the documentation, and for the database I can see ap

[ADMIN] Database level encryption

2010-04-03 Thread Timothy Madden
Hello Please how could I encrypt my database so data can be retrieved only with my password, when my client application starts, even if the database is captured ? I would like the encryption to be transparent at the application level, which needs only provide a password and then all the database