ServerCake India

What is the file that handles Postgresql’s configuration Settings on cPanel & WHM Server

postgresql file configuration on cpanel
File Handles Postgresql’s Configuration Settings on cPanel & WHM Server

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

/var/lib/pgsql/data/postgresql.conf

 

 

Editorial Team

Editorial Team at ServerCake India Blog is a team of experts in Server Administration, Business Development, Management, SEO Analyst & Graphic Designers with more than 5+ years of expertise.

Add comment