> Le paquet pgdg-redhat-repo.noarch 0:42.0-24 sera installé Sélection de /var/tmp/yum-root-4圎Z6S/ pour installation Modules complémentaires chargés : fastestmirror
#POSTGRESQL YUM REPO INSTALL#
# Install the repository RPM: sudo yum install -y
#POSTGRESQL YUM REPO DOWNLOAD#
Refer to the download section of the official documentation for all available versions.įirst, be sure your system is up-to-date: You can now comfortably work on your database-powered applications by embracing the scalability and adaptability of the PostgreSQL 14 database engine.At the time of writing this tutorial, the lastest release of PostgreSQL was 14.x. We have successfully installed, initialized, started, and enabled PostgreSQL 14 on RHEL 8. The syntax for granting a user privileges to a specific PostgreSQL database is as follows: # GRANT ALL PRIVILEGES ON DATABASE db_name to non_super_user The syntax for creating a PostgreSQL database is as follows: # CREATE DATABASE db_name
#POSTGRESQL YUM REPO PASSWORD#
The syntax for creating a non-superuser is as follows: # CREATE USER non_super_user WITH ENCRYPTED PASSWORD 'pa55word5' To confirm the existence of a superuser, execute the following command: # \duĪs you can see, this newly created root user has created a role and created a DB whereby he/she can create other users, databases, and tables. # CREATE ROLE root WITH LOGIN SUPERUSER CREATEDB CREATEROLE PASSWORD 'pa55word5' You can give this user the name of your choice. The superuser will be responsible for managing all other database users and their associated database roles. Now that you have the PostgreSQL 14 database installed and running, the first basic step to implement before other database configurations take place is creating a superuser. PostgreSQL Database User Management in RHEL 8 To directly access the database console, you could run the following command: $ sudo -u postgres psql From here, you can switch to the database console using the following command: $ psql You will be connected to the PostgreSQL database under the username postgres. To make your first connection to the PostgreSQL database server, run the following command. Next, start, enable and check the PostgreSQL database service. $ sudo /usr/pgsql-14/bin/postgresql-14-setup initdb You will need to execute the following command to initialize the PostgreSQL 14 database. Initializing PostgreSQL 14 Database in RHEL 8 $ sudo dnf install -y postgresql14-contrib To benefit from PostgreSQL 14 optional additional features, install its Contrib package. $ sudo dnf install -y postgresql14-server We can now proceed with the installation of the PostgreSQL 14 database server. The default built-in PostgreSQL module might lead to unwanted conflicts, make sure it is disabled. To include PostgreSQL 14 module, we need to set up its associated repository. If we list the default PostgreSQL modules, we might fail to note the inclusion of PostgreSQL 14.
Since this article’s objective is to specifically install PostgreSQL 14 server on our RHEL 8 system, we have to be careful not to install older PostgreSQL versions. The first step is to ensure your RHEL 8 system is up-to-date.
This article will take you through installing PostgreSQL 14 on RHEL 8. Therefore, whether you are working on analytics, geospatial, mobile, or web applications on an RHEL 8 environment, PostgreSQL’s flexibility with both structured and unstructured data makes it a reliable data warehouse/store. RHEL 8 on the other hand offers its users a quick Cybersecurity response, flexible subscription options, secure design, open APIs, and thorough product testing. These development milestones have earned PostgreSQL the attributes of being robust, performant, and reliable. The open-source nature of this relational database management system has kept it under an active development status for over 30 years. PostgreSQL is a well-known object-relational database system.
0 kommentar(er)
