/Shell/Bash/Backup postgres database docker

Backup postgres database docker

Pgrestore schema backup to a container

docker exec -i pg_container_name psql --username pg_username [--password pg_password] database_name < /path/on/your/machine/dump.sql

Source: davejansen.com

Backup postgres database docker

REM For Windows Systems - Only Schema
for /f %%i in ('powershell -c "get-date -format yyyyMMdd_HHmmss"') do @set DATETIME=%%i
docker exec -t pgdb_container pg_dump --username "your-username" --no-password --verbose --role "root" --format=p --schema-only --create --clean --encoding "UTF8" "your-database-name" > "%~dp0backup_%DATETIME%.sql"

REM For Windows Systems - Full Backup
docker exec -t pgdb_container pg_dump --username "your-username" --no-password --verbose --role "root" --format=p --create --clean --encoding "UTF8" "your-database-name" > "%~dp0backup_%DATETIME%.sql"


REM https://stackoverflow.com/a/48689986/9034699
REM Taken from pgAdmin during backup operation

Backup postgres database docker

docker exec -t your-db-container pg_dumpall -c -U postgres > dump_`date +%d-%m-%Y"_"%H_%M_%S`.sql

Source: stackoverflow.com

Similar codes

1 vote209 views1 answer
Get y.output file yacc remove shift reduce conflict
Shell/Bash
0 vote191 views1 answer
Ubuntu 20.04 vmware tools
Shell/Bash
9 votes195 views6 answers
Stop nginx server
Shell/Bash
24 votes220 views3 answers
Download brew
Shell/Bash
0 vote185 views1 answer
Install opencv2 homebrew
Shell/Bash
5 votes195 views2 answers
Pip install pyscopg2
Shell/Bash
7 votes220 views3 answers
UserWarning: Matplotlib is currently using agg, which is a non-GUI backend, so cannot show the figure. plt.show()
Shell/Bash
0 vote207 views1 answer
How to log into another linux machine using ip address
Shell/Bash
3 votes195 views2 answers
E: Unmet dependencies. Try 'apt --fix-broken install' with no packages (or specify a solution).
Shell/Bash
5 votes212 views2 answers
Get custom fields in result of mongodb query
Shell/Bash