Horje
backup postgres database docker Code Example
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



Shell

Related
docker.service: Failed with result 'exit-code' Code Example docker.service: Failed with result 'exit-code' Code Example
bash loop lines in file Code Example bash loop lines in file Code Example
javascript to exe Code Example javascript to exe Code Example
aws cli s3 list buckets Code Example aws cli s3 list buckets Code Example
how to mount windows folder on ubuntu Code Example how to mount windows folder on ubuntu Code Example

Type:
 Code Example
Category:
 Coding
Sub Category:
 Code Example
Uploaded by:
 Admin
Views:
 10



 

Horje