There is no default password for the postgresql user. In fact, our creation script configure the user to use sockets instead of password authentication.
You technically can set a password of your choice.
If you ensure that socket and password authentication works, this will also not be of an issue for Zammad.
( also mentioned here: DB Backup password? )