PostgreSQL Overview

PostgreSQL is an open source object-relational database system.

PostgreSQL is probably the most advanced database in the open source relational database market.
PostgreSQL uses and extends the SQL language combined with other features.

PostgreSQL superuser is the user named Postgres.

Supported platforms

PostgreSQL is available for all operating systems: Windows, Linux, Unix and macOS.

Supported Cloud vendors

Microsoft Azure

https://azure.microsoft.com/en-us/services/postgresql/

aws Amazon

https://aws.amazon.com/free/database/

IBM Cloud

https://www.ibm.com/cloud/databases-for-postgresql

ScaleGrid

https://scalegrid.io/postgresql.html

Google cloud SQL for PostgreSQL

https://cloud.google.com/sql/docs/postgres/

ElephantSQL PostgreSQL as a Service

https://www.elephantsql.com/

And more ...

Installation processes

Download PostgreSQL: https://www.postgresql.org/download

During the installation you will set:

• Database superuser (postgres) password.
• Port (default: 5432).

Client Tools

psql

psql is a command-line program.

psql can be used to enter SQL queries directly, or execute them from a file.

pgAdmin

pgAdmin is the PostgreSQL tool.

It's an Open Source administration and development platform for PostgreSQL.

pgAdmin is installed with PostgreSQL .

https://www.pgadmin.org/

A little bit of history

PostgreSQL evolved from the Ingres project at the University of California, Berkeley. At 1986 Michael Stonebraker and his colleagues developed Postgres.

Versions were released from time to time with more features, and in 1995 Initial release as Postgres95 was released.

In 1996 the project was renamed to PostgreSQL in order to reflect its support for SQL.

In 1997 the initial PostgreSQL release formed version 6.0.

Useful links

• PostgreSQL site: https://www.postgresql.org/
• postgresql.git: https://git.postgresql.org/gitweb/?p=postgresql.git
• PostgreSQL ODBC driver: https://www.progress.com/campaigns/datadirect/ppc/postgresql-odbc
• Configuration calculator: https://pgtune.leopard.in.ua/#/
• What is PostgreSQL? https://www.guru99.com/introduction-postgresql.html