I have installed postgreSql client 9.6 following this link postgreSql installation and I am using centos version 7 on Linux.
It got installed successfully but I am getting some problems while accessing that.
I try this.
[xyz@innolx20122 ~]$ su - postgres
Password:
which password need to enter here? I tried postgres which is not working.
I tried this also.
[xyz@innolx20122 ~]$ sudo -u postgres psql
[sudo] password for xyz:
could not change directory to "/home/xyz": Permission denied
psql (9.6.19)
Type "help" for help.
I was able to enter using my password. Is this the right way to enter postgres?
I saw many links on this but I am getting confused finally.