Ok, first let me apologize if this is the wrong board to post this, I only picked this one because it impacts several apps we have on UCS not just a single one.
We have installed several application, KIX4OTRS, Odoo, etc. All appear to use postgres/postgresql databases to store their configurations and backend data. We’d like to have nightly dumps of these databases so they get caught in the nightly Bareos backups we have. In searching google we have found several bash scripts that work on our other NON-UCS postgresql databases, however these same script fail with login as postgres user. We have tried the users created by the applications when installed, again these failed. We even tried root and this too failed. Is there a default postgres password installed?
How do we go about dumping our postgres/postgresql databases for backup/restore purposes?