Install and Configure PostgreSQL => Task failed

Hello @Inderpreet @Ayman @kodekloud-support3 , All

Install and Configure PostgreSQL - Task failed with error
“PostgreSQL is not configured correctly, either user ‘kodekloud_top’ and database ‘kodekloud_db1’ does not exist or user ‘kodekloud_top’ does not has appropriate permissions on database ‘kodekloud_db1’ on DB Server”

I would like to know what wrong was done
below are the screenshots attached for same

@nagesh , did you change some file for item d?

@francilio → vi /var/lib/pgsql/data/pg_hba.conf
“local” is for Unix domain socket connections only
local all all md5

I don’t remember how I’ve done this task, but I think you should restrict the user and database on pg_hba.conf. @Inderpreet @mmumshad may give a hint

@nageshd20 seems like after making changes in pg_hba.conf you missed to restart postgresql service.

@Inderpreet , Thank you task was successful

@jsripad Don’t spam. Single post is enough I guess.

@Tej-Singh-Rana removed posts in other threads.

I think this is resolved in another thread.

hello @nageshd20 I configured everything right on this task but when I restart the service “systemctl restart postgresql” it does not respond, it’s like the system is running a background process.
Screenshot from 2023-09-14 08-47-44