# Take backup pg_dump -F c -v DATABASE_NAME -f FILENAME.sql # Restore from backup pg_restore --verbose --clean --no-owner --no-acl --dbname DATABASE_NAME FILENAME.sql