![Centos install postgresql 12](https://cdn1.cdnme.se/5447227/9-3/22_64e61dfde087c31b3e70ff43.png)
# vi /var/lib/pgsql/15/data/pg_hba.confįind the following lines and change the authentication method to md5 as highlighted in the screenshot. The supported authentication methods include password-based authentication which uses one of these methods: md5, crypt, or password.įor this guide, we will configure the md5 authentication method in the file /var/lib/pgsql/15/data/pg_hba.conf. Now configure how the Postgres server will authenticate clients such as pgAdmin. $ psql -c "ALTER USER postgres WITH PASSWORD ' ' "ħ. Then switch to the Postgres system account and create a secure and strong password for PostgreSQL administrative database user/role as follows. Start by creating a password for a Postgres system user account using the passwd utility as shown.
![centos install postgresql 12 centos install postgresql 12](https://4.bp.blogspot.com/-RhQxndbmNl4/XSs4mViKEDI/AAAAAAAAF_M/MHb_7_pnJ0sj8dwYnRcSJbfYb1SVuKaYgCLcBGAs/s1600/05-centos-7-postgresql-pgadmin-database.png)
Next, secure the Postgres user account and the database administrative user account. Initialize PostgreSQL on RHEL 9 Step 2: Secure and Configure PostgreSQL Databaseĥ.
![centos install postgresql 12 centos install postgresql 12](https://comoinstalar.me/wp-content/uploads/2019/10/como-instalar-postgresql-en-centos-8.jpg)
# /usr/pgsql-15/bin/postgresql-15-setup initdb Then check if the service is up and running, and is enabled as shown. Once the installation is complete, initialize the PostgreSQL database, then start the PostgreSQL-15 service and enable it to automatically start at system boot. Next, install the PostgreSQL 15 server and client packages.
![centos install postgresql 12 centos install postgresql 12](https://dbtut.com/wp-content/uploads/2018/10/Ads%C4%B1z-7.png)
Next, enable the official PostgreSQL Yum Repository as shown.
![Centos install postgresql 12](https://cdn1.cdnme.se/5447227/9-3/22_64e61dfde087c31b3e70ff43.png)