Postgres, commonly known as PostgreSQL, is an advanced open-source relational database management system meant for general purpose. It’s a default database for macOS Server but can also be used in Linux, OpenBSD, FreeBSD, and Windows.
Postgres is designed to handle data of workloads from single machines to data warehouses or web services. It’s also designed to run on UNIX-like platforms such as macOS Servers though it can be found on Linux, Solaris, Windows, OpenBSD, and FreeBSD.
- Table inheritance
- User-defined types
- Complex locking mechanism.
- Nested transactions(savepoints)
- Foreign key referential integrity
- Views, rules, subquery.
- Asynchronous replication
- Multi-version concurrency control (MVCC)
History of postgres
The history of Postgres is dated back from the Ingres project that took place at the University of California, Berkeley, back in 1982. The post-Ingres project was meant to address the problem that the contemporary database system was facing.
The new Ingres project is meant to add features that will ultimately support data types. Its name has also transitioned from Postgres to PostgreSQL.