Skip to content

Instantly share code, notes, and snippets.

@dgierejkiewicz

dgierejkiewicz/Backup, restore postgres in docker container

Forked from gilyes/Backup, restore postgres in docker container
Created June 17, 2021 08:40
Show Gist options
  • Save dgierejkiewicz/b27e7bc530345c009f45f62d3561dd1d to your computer and use it in GitHub Desktop.
Save dgierejkiewicz/b27e7bc530345c009f45f62d3561dd1d to your computer and use it in GitHub Desktop.
Download ZIP

Revisions

  1. @gilyes gilyes revised this gist Jun 16, 2016. 1 changed file with 1 addition and 1 deletion.
    2 changes: 1 addition & 1 deletion Backup, restore postgres in docker container
    View file
    Original file line number Diff line number Diff line change
    @@ -1,5 +1,5 @@
    Backup:
    docker exec -t -u postgres *your-db-container* pg_dumpall -c > dump_`date +%d-%m-%Y"_"%H_%M_%S`.sql
    docker exec -t -u postgres your-db-container pg_dumpall -c > dump_`date +%d-%m-%Y"_"%H_%M_%S`.sql

    Restore:
    cat your_dump.sql | docker exec -i your-db-container psql -Upostgres
  2. @gilyes gilyes revised this gist Jun 16, 2016. 1 changed file with 1 addition and 1 deletion.
    2 changes: 1 addition & 1 deletion Backup, restore postgres in docker container
    View file
    Original file line number Diff line number Diff line change
    @@ -1,5 +1,5 @@
    Backup:
    docker exec -t -u postgres jira_postgres_1 pg_dumpall -c > dump_`date +%d-%m-%Y"_"%H_%M_%S`.sql
    docker exec -t -u postgres *your-db-container* pg_dumpall -c > dump_`date +%d-%m-%Y"_"%H_%M_%S`.sql

    Restore:
    cat your_dump.sql | docker exec -i your-db-container psql -Upostgres
  3. @gilyes gilyes revised this gist Jun 16, 2016. 1 changed file with 1 addition and 1 deletion.
    2 changes: 1 addition & 1 deletion Backup, restore postgres in docker container
    View file
    Original file line number Diff line number Diff line change
    @@ -1,5 +1,5 @@
    Backup:
    docker exec -t -u postgres jira_postgres_1 pg_dumpall -c > dump_`date +%d-%m-%Y"_"%H_%M_ %S`.sql
    docker exec -t -u postgres jira_postgres_1 pg_dumpall -c > dump_`date +%d-%m-%Y"_"%H_%M_%S`.sql

    Restore:
    cat your_dump.sql | docker exec -i your-db-container psql -Upostgres
  4. @gilyes gilyes revised this gist Jun 16, 2016. 2 changed files with 5 additions and 1 deletion.
    1 change: 0 additions & 1 deletion Backup postgres in docker container
    View file
    Original file line number Diff line number Diff line change
    @@ -1 +0,0 @@
    docker exec -t -u postgres jira_postgres_1 pg_dumpall -c > dump_`date +%d-%m-%Y"_"%H_%M_ %S`.sql
    5 changes: 5 additions & 0 deletions Backup, restore postgres in docker container
    View file
    Original file line number Diff line number Diff line change
    @@ -0,0 +1,5 @@
    Backup:
    docker exec -t -u postgres jira_postgres_1 pg_dumpall -c > dump_`date +%d-%m-%Y"_"%H_%M_ %S`.sql

    Restore:
    cat your_dump.sql | docker exec -i your-db-container psql -Upostgres
  5. @gilyes gilyes created this gist Jun 16, 2016.
    1 change: 1 addition & 0 deletions Backup postgres in docker container
    View file
    Original file line number Diff line number Diff line change
    @@ -0,0 +1 @@
    docker exec -t -u postgres jira_postgres_1 pg_dumpall -c > dump_`date +%d-%m-%Y"_"%H_%M_ %S`.sql