The Research And Implementation Of The Parse Of The PostgreSQL Protocol Based On Database Audit System

With its excellent performance and open source features,the PostgreSQL database has been widely used.The PostgreSQL database system has multi-level security mechanism,but any system's security protection measures are not perfect.People who deliberately steal or destroy data always try to break the control.Therefore,it is particularly important to set up independent auditing institutions,record all operations of users on databases,help DBA find out people,time and contents of illegally accessing data.This paper mainly studies the integration of the PGSQL protocol and the design and implementation of the database security audit system for the parsing of the PGSQL protocol.First,we study the PGSQL protocol.This paper first summarizes the PGSQL protocol on the protocol framework.Using WireShark tool and PostgreSQL official documents,we study the structure of PGSQL protocol packet,and test the uncertain fields based on open source code,so as to realize the parsing of PGSQL protocol.On this basis,we study the framework and process flow of the database security audit system.The parsing of PGSQL protocol improves the audit ability of data security audit system to database operation,and realizes the audit of PostgreSQL database by database audit system.There are few studies on the analysis of the PGSQL protocol in the existing data.The work completed in this project will make a certain contribution to the security audit of the PostgreSQL database.