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 can be accessed, and I would like to store my database on any filesystem on my client's computers. so I do not want filesystem ecryption either. My client has a proximity advertising application, running with a local PostgreSQL database, that they install on many computers from several client companies, to cover many spots on a given geographic area. The application always starts with my password, and my client will be the only one that can start or stop it, and I would like the application data in the database to be protected by that same password. I can only see how PostgreSQL encrypts the password or the connection in the documentation, and for the database I can see application-level encryption with pgcrypto (and filesystem level encryption), How could I get database level encryption in PostgreSQL ? -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
