23-08-2022
What is DBMS?
• Data is a collection of a distinct small unit of information, that can be used in a
001 PostgreSQL Training Session variety of forms like text, numbers, media, bytes, etc. it can be stored in pieces of
paper or electronic memory, etc.
Introduction • Database is an organized collection of data, so that it can be easily accessed and
managed
• DBMS or Database Management System is a software to Store and Manage
Database
• Types of DBMS
– Relational
Training Developed and Conducted by:
– Object Oriented
NAVEEN MALHOTRA – Distributed
Database Consultant – Network
M: 9810172802 – Hierarchical
navi164@[Link]
– NoSQL
Session Contents About PostgreSQL
• Introduction to PostgreSQL • PostgreSQL is an DBMS
• History • Object Relational Database Management System (ORDBMS)
• Major Features • It has features like Object Oriented Programing Languages, e.g. Inheritance
• Architecture • Some of the key feature of PostgreSQL are:
– PostgreSQL is used under Open Source License, and is FREE
– Written in C
– Latest release version: 14.x, as on Aug 2022
– Platform Independent (FreeBSD, Linux, macOS, OpenBSD, Windows)
– Low Maintenance
– Active Community Support
– Standard Connectivity including ODBC, JDBC, etc.
– ACID Compliant
23-08-2022
History of PostgreSQL Who is using PostgreSQL?
• Evolved from Ingres project at the University of California, Berkeley
• 1986: Published papers described the basis of the system
• 1998: Prototype version was shown
• 1989: Team released version 1 to a small number of users
• 1990: Released version 2 with a re-written rules system
• 1991-1993: Multiple version released
• 1994: Project ended. Code made public that uses POSTQUEL query language
• 1994: Berkeley graduates Andrew Yu and Jolly Chen replaced the POSTQUEL with
one for the SQL query language, creating Postgres95
• 1995: Announced the first version GA Version 1.0 of Postgres95
Multiple Big and small brands use PostgreSQL. However, maximum of the
• 1996: Project was renamed to PostgreSQL to reflect its support for SQL
organizations use hybrid model for DB technology and use PostgreSQL for those
• Thereafter project continues to make releases available under its free and open- applications where it could be best suited.
source software PostgreSQL License
Version History How much does PostgreSQL Cost?
• PostgreSQL is an Open Source Database and hence, Download, Installation, Usage
is absolutely free! Community version is the only version available which is freely
downloadable.
• For using PostgreSQL for Enterprise Production, you can’t rely on community blog
support as it might have slower response at times. Hence, there are multiple third-
party vendors available who provide support and charge you as per the aggression
of SLA. [Link] (Top 5 listed
below)
• [Link]
• [Link]
• [Link]
• [Link]
• [Link]
23-08-2022
PostgreSQL on Cloud
• Supported by all major Cloud Vendors
• Provided as DaaS (Database as a Service)
• AWS: RDS for PostgreSQL
• Azure: Azure Database for PostgreSQL
• GCP: Cloud SQL for PostgreSQL
• Good option to choose if suits our Technical requirements and Budget Thank You
• Major admin functions can be taken care of by Cloud Vendors
for you Patience!
We welcome your Questions!
Q&A