Postgres - Install and Configure

local all all md5
credentials that you have to set to local clients are able to access the database.

@player001 how about the ip range not required ?

@kaushik task is about local clients so where we need ip address.
add local all all md5
here is the solution of your questions
Hope it will help you to understand your query.
thanks,

1 Like

Hi @Inderpreet, I also had this problem even I have installed and configured Postgresql as required but it shows the task as failure.



Please check the below steps which I performed during the installation and configuring the PostgreSQL

  1. sudo yum install postgresql-server postgresql-contrib
  2. sudo postgresql-setup initdb
  3. sudo systemctl enable postgresql && sudo systemctl start postgresql
  4. echo -n ‘BruCStnMT5’ | md5sum
  5. sudo -u postgres psql postgres
  6. CREATE USER kodekloud_joy WITH ENCRYPTED PASSWORD ‘1de08cde294b11aa10e2d39b30286c95’;
  7. CREATE DATABASE kodekloud_db3 OWNER kodekloud_joy;
  8. GRANT ALL PRIVILEGES ON DATABASE kodekloud_db3 TO kodekloud_joy;
  9. sudo vi /var/lib/pgsql/data/pg_hba.conf
  10. sudo vi /var/lib/pgsql/data/postgresql.conf
  11. sudo systemctl restart postgresql.service
  12. psql -U kodekloud_joy -d kodekloud_db3 -h 127.0.0.1 -W

Can you please check ?

@fazalmahmood this is marked Success for you.

I am having the same issue. Anyone please help me.
@Inderpreet @player001 @mmumshad @fazalmahmood.

I did the same process as you described @fazalmahmood but it shows failed login with error message as "psql: FATAL: password authentication failed for user “kodekloud_user” . There is one thing I need to know that what to write in “postgresql.conf” and “pg_hba.conf” files or what else I need to change in the process @mmumshad @Inderpreet @player001 @kaushik .

Already described there compare with your pg_hba.conf file. You have to setup connection for local and authentication with md5 encrypted password so change peer to md5.

@rakshita I think you made mistake here
echo -n ‘BruCStnMT5’ | md5sum

you should replace BruCStnMT5 with your password as mentioned in your task and use the md5 output in following command

CREATE USER “KODEKLOUD_USER_HERE” WITH ENCRYPTED PASSWORD ‘YOUR_MD5_WILL_BE_HERE’;

and uncomment “listen_addresses” in postgresql.conf and replace existing Method with md5 in pg_hba.conf

Hope It’ll work for you

I have used my password only. And did all the configurations as you mentioned. Still not working???
@fazalmahmood

You don’t need to convert the password into md5.

I performed the whole task in right way but still unable to login to user and resulted in task failure.
Please check @Inderpreet @mmumshad @player001 @fazalmahmood @kaushik.
Screenshot (306)|690x210

@rakshita Change method from ident to md5 in IPv4 local connections, below line where you changed previously