PostgreSQL is a powerful, open source object-relational database system.
It has more than 15 years of active development and a proven architecture that has earned it a strong reputation for reliability, data integrity, and correctness.
PostgreSQL features include:
- Runs on all major operating systems, including Linux, UNIX (AIX, BSD, HP-UX, SGI IRIX, Mac OS X, Solaris, Tru64), and Windows
- Referential integrity
- Fully ACID compliant
- Supports foreign keys, joins, views, triggers, and stored procedures (in multiple languages)
- It includes most SQL:2008 data types, including INTEGER, NUMERIC, BOOLEAN, CHAR, VARCHAR, DATE, INTERVAL, and TIMESTAMP
- Supports storage of binary large objects, including pictures, sounds, or video
- Supports partitioning
- Supports tablespaces
- Schemas
- Online backup
- Point-in-time recovery
- Master-Slave replication
- Native programming interfaces for C/C++, Java, .Net, Perl, Python, Ruby, Tcl, ODBC, among others
- GIS indexing
- Distributed database