backup postgres database
pg_dump -h localhost -U postgres -W -d mydb > mydb.sqlbackup postgres database
pg_dump -h localhost -U postgres -W -d mydb > mydb.sqlbackup 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 operationbackup postgres database docker
docker exec -t your-db-container pg_dumpall -c -U postgres > dump_`date +%d-%m-%Y"_"%H_%M_%S`.sqlCopyright © 2021 Codeinu
Forgot your account's password or having trouble logging into your Account? Don't worry, we'll help you to get back your account. Enter your email address and we'll send you a recovery link to reset your password. If you are experiencing problems resetting your password contact us
