Edward Almanzar edardev

## Strapi, Hasura Postgres and pgAdmin4 with docker-compose.md

      
              2 files
            
          
              0 forks
            
          
              0 comments
            
          
              1 star
            
          
                edardev
                / Strapi, Hasura Postgres and pgAdmin4 with docker-compose.md
            
            
              Last active
              August 19, 2020 17:44
            
          
    Strapi, Hasura Postgres and pgAdmin4 with docker-compose


## Backup and restore PostgreSQL.md

      
              1 file
            
          
              1 fork
            
          
              0 comments
            
          
              2 stars
            
          
                edardev
                / Backup and restore PostgreSQL.md
            
            
              Last active
              June 25, 2021 07:28
            
          
    Backup and Restore Postgres databases

https://www.postgresqltutorial.com/postgresql-backup-database/
Backup a specific database use pg_dump

docker exec -t your-db-container pg_dump -U strapi -W -F t database-name > mypostgres_strapi_`date +%d-%m-%Y"_"%H_%M_%S`.sql

Backup all databases use pg_dumpall

docker exec -t your-db-container pg_dumpall -c -U postgres > dump_`date +%d-%m-%Y"_"%H_%M_%S`.sql