Skip to content

Instantly share code, notes, and snippets.

@xensbakuli

xensbakuli/TimescaleDb.md

Forked from somerongit/TimescaleDb.md
Created March 27, 2025 07:16
Show Gist options
  • Save xensbakuli/df4032d71152f10eb39cf8e5cb99d6b1 to your computer and use it in GitHub Desktop.
Save xensbakuli/df4032d71152f10eb39cf8e5cb99d6b1 to your computer and use it in GitHub Desktop.
Download ZIP

Revisions

  1. @somerongit somerongit renamed this gist Jan 27, 2025. 1 changed file with 0 additions and 0 deletions.
    0 Readme.md → TimescaleDb.md
    View file
    File renamed without changes.
  2. @somerongit somerongit created this gist Jan 27, 2025.
    11 changes: 11 additions & 0 deletions Readme.md
    View file
    Original file line number Diff line number Diff line change
    @@ -0,0 +1,11 @@
    ## Timescale DB

    ### Backup
    ```
    docker exec -i postgres pg_dump -d postgres://user:password@postgres_service:5432/db | gzip > ./backup.sql.gz
    ```
    ### Restore
    ```
    gunzip backup.sql.gz
    docker exec -i postgres psql -d postgres://user:password@postgres_service:5432/db < backup.sql
    ```