What is Postgresql?
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. This system runs on the all major operating systems, including UNIX (AIX, BSD, HP-UX, SGI IRIX, Mac OS X, Solaris, Tru64), Windows, and Linux. It is fully ACID compliant, has full support for foreign keys, joins, views, triggers, and stored procedures (in multiple languages). It also includes most of the SQL data types, including CHAR, VARCHAR, DATE, INTERVAL, INTEGER, NUMERIC, BOOLEAN and TIMESTAMP. It supports storage of binary large objects, including pictures, sounds, or video. The native programming interfaces of this system includes for C/C++, Net, Perl, Python, Java, Ruby, Tcl, ODBC, among others, and expectational database. It can be configured through Postgresql’s configuration files.
Postgresql’s configuration file
PostgreSQL.conf Include files or directories can be used to logically separate portions of the database configuration, rather than having a single large postgresql.conf file. Consider that a company that has two database servers, each database with a different amount of limit memory
Command to access PostgreSQL.conf file