Backup/Restore a Dockerized PostgreSQL Database
Enter in PostgreSQL container and View database list: docker exec -it <container-id> psql -W -U db_user DB_name (IF DB_USER_NAME and DB_NAME is not same) docker exec -it <container-id> psql -U postgres (If DB_USER_NAME and DB_NMAE is same as postgres) To list database : \l To use database: \c <database-name> To list tables: \d Now Exit from PostgreSQL: \q Backup Your Database: a. Command to backup a local or remote PostgreSQL database: docker exec -i <PostgreSQL-container-id> pg_dump -U postgres -d <database-name> > prod_db_dump_`date +%d-%m-%Y”_”%H_%M_%S`.sql (Ask for postgres password) or echo -n "password" | docker exec -i 323f6ab197b1 pg_dump -U dbuser -d db_name > /home/prod_db_dump_`date +%d-%m-%Y”_”%H_%M_%S`.sql (Never Ask for Password) b. Command to backup multiple PostgreSQL databases : docker exec -i <PostgreSQL-container-id> pg_dumpall -U postgres -d <database-name> > prod_db_dump_`date ...