Chapitre 4. Using PostgreSQL
The PostgreSQL server is an open source robust and highly-extensible database server based on the SQL language. This part describes how to install and configure PostgreSQL on a RHEL system, how to back up PostgreSQL data, and how to migrate from an earlier PostgreSQL version
4.1. Getting started with PostgreSQL
The PostgreSQL server provides an object-relational database system, which allows you to manage extensive datasets and a high number of concurrent users. For these reasons, the PostgreSQL servers can be used in clusters to manage high amounts of data.
The PostgreSQL server includes features for ensuring data integrity, building fault-tolerant environments, and building applications. It allows users to extend a database with users' own data types, custom functions, or code from different programming languages without the need to recompile the database.
This part describes:
- How to install PostgreSQL in Installing PostgreSQL.
- Users, roles, and privileges in Creating PostgreSQL users.
- How to adjust PostgreSQL configuration in Configuring PostgreSQL.
- How to enable Transport Layer Security (TLS) support on the PostgreSQL server in Configuring TLS encryption on a PostgreSQL server.
- How to back up your databases in Backing up PostgreSQL data.
- How to migrate to the RHEL 9 version of PostgreSQL in Migrating to a RHEL 9 version of PostgreSQL. One of the prerequisites of migration is performing a data backup.