PostgreSQL, often referred to as Postgres, is an open-source relational database management system (RDBMS) known for its robustness, extensibility, and adherence to SQL standards.
PostgreSQL is a relational database, meaning it organizes data into tables with rows and columns, and supports SQL (Structured Query Language) for querying and managing data.
PostgreSQL offers a wide range of features including ACID compliance (Atomicity, Consistency, Isolation, Durability), full support for foreign keys, joins, views, triggers, and stored procedures. It also supports a variety of data types including JSON, XML, and arrays.
PostgreSQL Features
Open Source
Relational Database
Features
Extensibility
Scalability and Performance
Community Support
Cross-Platform Compatibility
Enterprise Ready
Replication and High Availability
Security
Postgre SQL works on a client/server model. Postgre SQL server can manage several concurrent connections from clients. It provides support for one storage engine with close integration between the storage engine and the rest of the database. Postgre SQL can compress and decompress its data through a fast compression scheme to fit more data in the allotted disk space. Apart from saving the disk space, another important benefit of compressed data is that reading of this data requires less IO thus resulting in faster data reads. Postgre SQL runs on operating systems like UNIX, Linux and programming languages like C, C++, Java, Perl, Python, and Ruby.
Steps For Installing & Configuring PostgreSQL
Open terminal or login via putty SSH
Run the below command
/usr/local/cpanel/scripts/installpostgres
After complete the above installation,
Go to ‘Configure Postgre SQL Interface’ (Home >> SQL Services >> Configure PostgreSQL).
- For installing Postgre SQL, click on ‘Install Config’.
- For adding current cPanel users to Postgre SQL, click on ‘Create Users’.
- Enter the password in the ‘Enter New Password’ section, re-enter it in the ‘Confirm Password’ section.
- When you have entered the password, click on ‘Change Password’.
To Restart Postgre SQL
Execute this command for editing the Postgre SQL Confirmation file
vim /var/lib/pgsql/data/postgresql.conf file
That’s it
To upgrade apache and php with cpanel click here.