2/2/2023 0 Comments Postgresql 9.6 downloadThe above two commands sho uld run without errors. configure -prefix=/usr/local/pgsql -with-openssl Make sure you enable openssl by passing -with-openssl: Default is /usr/local/pgsql which I am using here for example. You can choose where all files will be installed by passing -prefix. Sudo apt-get install libreadline8 libreadline-dev zlibc zlib1g-dev bison flex libssl-dev openssl Run configure from the source code directory: Sudo chown postgres:postgres /usr/local/pgsql/data Install the libraries for readline, bison, flex, openssl, zlib and crypto: Create data directory for PostgreSQL: Just for example, I am creating it at the default location: You can download the patch for this here. In this blog, we go through the basic steps used to install PostgreSQL 9.6 with Transparent Data Encryption (TDE) on Ubuntu. The encryption is transparent, so the applications see no difference between the encrypted and unencrypted clusters. If cluster encryption is enabled, PostgreSQL encrypts data (both relations and write-ahead log) when writing to disk, and decrypts it when reading. Posted on by Granthana Biswas Cluster encryption can be used if the DBA cannot or does not rely on the file system in terms of confidentiality.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
May 2023
Categories |