History of PostgreSQL

History of PostgreSQL

The world’s most advanced open source database

Designed for extensibility and customization .

Actively developed for more than 20 years

- University Postgres (1986-1993)

- Postgres95 (1994-1995)

- PostgreSQL (1996-current)

Features of PostgreSQL

Portable:

Written in ANSI C

Supports Windows, Linux, Mac OS/X and major UNIX platforms

Reliable:

•  ACID Compliant
•  Supports Transactions
•  Supports Save points
•  Uses Write Ahead Logging (WAL)

Secure:

• Uses Multi-version Concurrency Control
• Supports Table Partitioning
• Supports Tablespaces

Recovery and Availability: 

•  Streaming Replication
•  Replication Slots
•  Supports Hot-Backup, pg_basebackup
•  Point-in-Time Recovery

Advanced:

• Supports Triggers and Functions
• Supports Custom Procedural Languages PL/pgSQL, PL/Perl, PL/TCL, PL/PHP, PL/Java - Upgrade using pg_upgrade
• Unlogged Tables - Materialized Views

• what is postgreSQL
• Why postgresSQL
• History of PostgreSQL
• postgreSQL - PSQL MATA Commands
• postgreSQL what is schema?
• postgreSQL Connecting to a Database
• postgreSQL Create and access Database
• How to create user in postgreSQL?
• postgreSQL Grant/Revoke Privileges
• postgreSQL Tablespaces and datafiles
• postgreSQL How to start server and stop server?
• postgreSQL perfomance
• postgreSQL How to create cluster?
• postgreSQL Queries
• postgreSQL routine maintenance and proactive-maintanace.
• postgresql-logging