Apologies for such a slow response, I've been away from my desk...
PostgreSQL default user uses socket authentication, so when you using via CLI, you don't need to use the password if you su as the user. I.e. you should be able to issue commands like this (with no password required):
su - postgres -c "psql COMMAND GOES HERE"
If you wish to access PostgreSQL remotely though, you need to make PostgreSQL listen for remote connections, plus allow remote connections too. You can find how to do that in the docs.
PostgreSQL default user uses socket authentication
Apologies for such a slow response, I've been away from my desk...
PostgreSQL default user uses socket authentication, so when you using via CLI, you don't need to use the password if you su as the user. I.e. you should be able to issue commands like this (with no password required):
If you wish to access PostgreSQL remotely though, you need to make PostgreSQL listen for remote connections, plus allow remote connections too. You can find how to do that in the docs.
I hope that helps...