The Design of Postgresql’s Security Protection Scheme
Peng Lu, Fang Lou · 2023
Postgresql is a widely used open source database, but it pays more attention to its general functions and performance, and the data security protection measures are seriously insufficient. Aiming at the problems of database security protection such as authentication password leakage and malicious copy of data, this paper studies postgresql database security protection mechanism and the data encryption, including database security protection model, authentication password leakage protection mechanism and underlying data malicious copy protection mechanism. Postgresql’s security protection scheme designed in this paper can break through the key problems such as abnormal data identification in high confusion mode, homomorphic migration of data operation and performance balance, and focus on solving two sensitive data leakage hidden dangers, such as fake login and copy & restore datas, so as to provide security for data storage.