![]() > Traitement de la dépendance : libicui18n.so.50()(64bit) pour le paquet : 86_64 > Traitement de la dépendance : libicuuc.so.50()(64bit) pour le paquet : 86_64 > Traitement de la dépendance : libpq.so.5()(64bit) pour le paquet : 86_64 > Traitement de la dépendance : postgresql14-libs(x86-64) = 14.2-1PGDG.rhel7 pour le paquet : 86_64 > Le paquet postgresql14-server.x86_64 0:14.2-1PGDG.rhel7 sera installé Paquet : de : /etc/pki/rpm-gpg/RPM-GPG-KEY-PGDG ID utilisateur : « PostgreSQL RPM Building Project »Įmpreinte : 68c9 e2b9 1a37 d136 fe74 d176 1f16 d2e1 442d f0f8 Récupération de la clé à partir de file:///etc/pki/rpm-gpg/RPM-GPG-KEY-PGDG Loading mirror speeds from cached hostfile $ sudo yum install -y postgresql14-server Pgdg-redhat-repo noarch 42.0-24 /pgdg-redhat-repo-latest.noarch 11 k > 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 # Install the repository RPM: sudo yum install -y Refer to the download section of the official documentation for all available versions.įirst, be sure your system is up-to-date: That’s all from this post, please do post your queries and feedback on below comments section.At the time of writing this tutorial, the lastest release of PostgreSQL was 14.x. Perfect, above output confirms that postgres user and database is secure now. This time it should prompt you to enter password first, $ su - postgres Let’s try to switch to postgres user and connect to database. ![]() $ psql -c "ALTER USER postgres WITH PASSWORD ‘xxxxxxxxxxx' " Now to secure database, set password to postgres user using passwd command. ![]() 5) Securing PostgreSQL 15 Databaseīy default, postgresql database is not secure, one can easily switch to postgres user without any password and start using psql as shown below: To verify its service status, run $ sudo systemctl status postgresql-15Ībove output shows that postgresql service is up and running. Run the following systemctl commands to start and enable postgresql 15 service. ![]() To initialize PostgreSQL 15 initdb database, run $ sudo /usr/pgsql-15/bin/postgresql-15-setup initdb 3) Initialize PostgreSQL Database (initdb) Now, let initialize its database in the next step. $ psql -VĪbove command’s output shows PostgreSQL 15.1 is installed on the system. Once postgresql and it’s dependencies are installed, verify its version using following psql command. $ sudo dnf install postgresql15-server -y In step 1, we have already configured PostgreSQL 15 package repository, so to install it, run the beneath dnf command. So, let’s first enable its DNF/yum package repository using following dnf command. PostgreSQL 15 is not available in the default package repositories of RHEL 9. 1) Enable PostgreSQL 15 Package Repository
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |