Skip to content

Instantly share code, notes, and snippets.

@lnxph-devops-sareno

lnxph-devops-sareno/README.md

Created May 18, 2025 07:54
Show Gist options
  • Save lnxph-devops-sareno/1f295233376822dd646a23d159c9d64e to your computer and use it in GitHub Desktop.
Save lnxph-devops-sareno/1f295233376822dd646a23d159c9d64e to your computer and use it in GitHub Desktop.
Download ZIP

Revisions

  1. lnxph-devops-sareno revised this gist May 18, 2025. No changes.
  2. lnxph-devops-sareno created this gist May 18, 2025.
    18 changes: 18 additions & 0 deletions README.md
    View file
    Original file line number Diff line number Diff line change
    @@ -0,0 +1,18 @@
    ## Create backup on the source database
    ### Note:
    Owner and privileges are excluded.

    ```bash
    pg_dump -U src_db_user -h src-db.example.com -d src_db_name --no-owner --no-privileges -F c -f mybackup-yyyMMddHHmmss.dump
    ```

    ## Restore backup to the destination database
    ### Create backup first before restoring
    ```bash
    pg_dump -U dst_db_user -h dst-db.example.com -d dst_db_name --no-owner --no-privileges -F c -f backup_before_restore-yyyMMddHHmmss.dump
    ```

    ### Restore
    ```bash
    pg_restore -U dst_db_user -h dst-db.example.com -d dst_db_name --no-owner --no-privileges --disable-triggers mybackup-yyyMMddHHmmss.dump
    ```