![]() The Asynchronous, Synchronous replication is used to replicateĭata from one server to another server and the Point-in-time recovery (PITR) mechanism is used to recover the data in case of any data corruption. PostgreSQL uses the Write-ahead Logging (WAL) to store the data and provides the data assurance without losing it. ![]() To maintain the best Data Integrity, PostgreSQL support all standard constraints such as Primary Keys, Foreign Keys, UNIQUE, NOT NULL, and Exclusion Constraints. Polygon) and the Customized data types defined by the users. Structured that contains (Date-Time, Array, Range- Multirange, UUID), Document that contains (JSON-JSONB, XML, Key-value (Hstore), Geometry that contains (Point, Line, Circle, The major Data types of PostgreSQL are Primitives which contain (Integer, Numeric, String, Boolean), PostgreSQL supports different types of data types to perform various operations. The following are some of the important features PostgreSQL is the most advanced open-source object-relational database management system which is loaded with many important features. PostgreSQL supports Geographic Information System by adding the PostGIS extension to run the location query in SQL.PostgreSQL supports the native data types of JSON, Hstore, XML, and C-store to convert the PostgreSQL database into a NoSQL database.SSPI to secure the connection from any attack. To maintain security between client and database, PostgreSQL uses the advanced level of Authentication methods such as SSL encryption, LDAP, SCRAM-SHA-256, GSSAPI Certificate, and.PostgreSQL maintains the Write-ahead Logging (WAL) for the data protection and point in time recovery using Asynchronous, Synchronous replications. ![]() SPGist, multi-columns stats, GiST, BRIN, GIN, and so on.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |