Postgresql on Debian10
作者 Apps4Rent LLC
PostgreSQL is a powerful, open source object-relational database system by Apps4Rent.
PostgreSQL has earned a strong reputation for its proven architecture, reliability, data integrity, robust feature set, extensibility, and the dedication of the open source community behind the software to consistently deliver performant and innovative solutions.
PostgreSQL comes with many features aimed to help developers build applications, administrators to protect data integrity and build fault-tolerant environments, and help you manage your data no matter how big or small the dataset. In addition to being free and open source, PostgreSQL is highly extensible. For example, you can define your own data types, build out custom functions, even write code from different programming languages without recompiling your database!
Few Key Feature of PostgreSQL:
- User-defined types
- Table inheritance
- Sophisticated locking mechanism
- Foreign key referential integrity
- Views, rules, subquery
- Nested transactions (savepoints)
- Multi-version concurrency control (MVCC)
- Asynchronous replication
- Text, images, sounds, and video, and includes programming interfaces for C / C++, Java, Perl, Python, Ruby, Tcl and Open Database Connectivity (ODBC).
- A lot of features of SQL like Complex SQL queries, SQL Sub-selects, Foreign keys, Trigger, Views, Transactions, Multiversion concurrency control (MVCC), Streaming Replication (as of 9.0), Hot Standby (as of 9.0).
- Table can be set to inherit their characteristics from a "parent" table. You can install several extensions to add additional functionality to PostgreSQL.
Disclaimer: Apps4Rent does not offer commercial licenses of any of the products mentioned above. The products come with open source licenses. You must bring your own licenses.
Default ports:
SSH: 22 TCP/UDP
PostgreSQL: 5432 TCP (Private Network)
HTTP: 80 TCP
HTTPS: 443 TCP