[shreyas@myapp(add_postgres_addapter)]$ su - postgres Password: su: Sorry [shreyas@myapp (add_postgres_addapter)]$
It is asking me the password, whereas I don't know the password of the user `postgres`. How would I create a new role with a password in this case ?
The user whose password has visibly been lost is not the database user postgres, but the OS user postgres. If you have root on this server access, simply enforce the password to a new value.