The best option for the password is to lower security so it’s not required to enter a password when you log into postgres
Category: VCSA
switch to postgres user in linux
On the VCSA you may want to switch to the postgres user to run some postgres commands it may be locked out. The commands below show how to make this user available