SQL

postgresql pg_dump

pg_dump -U user -d db_name -h 127.0.0.1 > dump.sql 

postgres make sql dump

pg_dump -U username dbname > dbexport.pgsql

postgres dump

----------- DOCKER ----------
## Dump
docker exec -i pg_container_name /bin/bash -c "PGPASSWORD=pg_password psql --username pg_username database_name" > /desired/path/on/your/machine/dump.sql

## Restore
docker exec -i pg_container_name /bin/bash -c "PGPASSWORD=pg_password psql --username pg_username database_name" < /path/on/your/machine/dump.sql

pg_dump

pg_dump -U postgres -h localhost --format=c --file=name_backup.sqlc database_name