PostgreSQL overview |
PostgreSQL is an open source object-relational database, developed by the global volunteer development team of the PostgreSQL community. PostgreSQL supports most of the SQL standards and provides many other modern features with a good reputation for data integrity and correctness, i.e., complex queries, foreign keys, triggers, views, transactional integrity, Multi-version concurrency control(MVCC), etc.
PostgreSQL can be used to store security information in iServer/iPortal/iEdge. In iPortal, PostgreSQL can also be used to store portal data.
For more information on PostgreSQL, please refer to the PostgreSQL official website: https://www.postgresql.org.
This article describes Installing and configuring PostgreSQL on Windows systems and Linux systems to help you get started with PostgreSQL and use it in iServer/iPortal/iEdge.
1. PostgreSQL uses the following ports by default. If the firewall is enabled, ensure that the following ports are accessible: