How to backup a AWX postgres database in docker.

postgres.docker.backup.txt

To backup:
docker exec -u <your_postgres_user> <postgres_container_name> pg_dump -Fc <database_name_here> > db.dump

To drop db (Don't do it on production, for test purpose only!!!):
docker exec -u <your_postgres_user> <postgres_container_name> psql -c 'DROP DATABASE <your_db_name>'

To restore:
docker exec -i -u <your_postgres_user> <postgres_container_name> pg_restore -C -d postgres < db.dump

working example for awx postgres database
backup:
docker exec -u postgres postgres pg_dump -Fc awx > `date +%m.%d.%y_%H.%M.%S`_awx_db.dump

RESTORE:
docker stop awx_task
docker stop awx_web
docker stop memcached

rename current db:
docker exec -u postgres postgres psql postgres awx -c 'ALTER DATABASE "awx" RENAME TO "awx_01_03_18"'

restore AWX db:
docker exec -i -u postgres postgres pg_restore -C -d postgres < 01.03.18_03.17.33_awx_db.dump

docker start memcached
docker start awx_web
docker start awx_task

if you are happy with everything you can drop your other database:
docker exec -u postgres postgres psql -c 'DROP DATABASE awx_01_03_18'

These seemed to work:

# docker exec -t awx_postgres pg_dump -U awx awx > /var/lib/awx/projects/awx-dump.sql

# docker exec -t awx_postgres psql -U awx awx < /var/lib/awx/projects/awx-dump.sql

or

root@AWX-3-panel:~# docker stop awx_task

awx_task

root@AWX-3-panel:~# docker stop awx_web

awx_web

root@AWX-3-panel:~# cp /var/lib/awx/projects/awx-dump.sql /root/.awx/pgdocker/10/data/

root@AWX-3-panel:~# docker exec -it awx_postgres /bin/bash

root@ce48e2584014:/#

root@ce48e2584014:/# dropdb -U awx awx

root@ce48e2584014:/# createdb -U awx awx

root@ce48e2584014:/# psql -U awx awx < /var/lib/postgresql/data/awx-dump.sql

root@ce48e2584014:/# exit

exit

root@AWX-3-panel:~# docker start awx_task

awx_task

root@AWX-3-panel:~# docker start awx_web

awx_web