In addition, for newbies like me who need to perform a dump from embedded Postgre DB, the easiest way is :
Create a temporary port-forward between AWX postgre DB and your computer with :
- Get information about Postgre DB with :
# retrieve your secret's name, something like awx-postgres-configuration
kubectl get secrets
# show secrets
kubectl get secrets awx-your-instance-postgres-configuration -o yaml
- Decode with a base64 decoder the following datas ( ’ | base64’ if you use Linux, else use an online decoder)
data:
database: xxxxx
host: xxxxx
password: xxxxx
port: xxxxx
type: xxxx
username: xxxx
- Create a temporary port-forward between your postgre pod and your computer
kubectl port-forward awx-your-postgre-pod 5432:5432
- Finally, you can access the DB with any tools you got, in my case DBeaver, then perform a Backup.
