🟢 Lesson 9: How to set up SSL/TLS connections in PostgreSQL
Enabling SSL authentication for server connections is one way to ensure data privacy. PostgreSQL provides support for SSL connections to the database server, thereby ensuring that all messages exchanged between the client and server are encrypted.
0:00 Start
0:13 Installing dependencies
0:54 Rebuilding the DBMS, adding the openssl library
6:52 Generating a 2048-bit RSA private key with AES encryption
7:25 Delete the passphrase on the newly created key
7:55 Assign the necessary rights to the key
8:10 Create a certificate file
8:44 Duplicate the certificate
8:56 Adding changes to the database configuration file
9:13 Adding changes to the database connection file
9:30 Restarting the database
10:04 The end
#postgresql #dbms #postgres #ssl #tls
