Backup: pg_dump -p 5432 database_name > database_name_data.sql Restore backup dump into local db psql -U username -d database_name -f objects.sql pg_restore --verbose --clean --no-acl --no-owner -h localhost -d [db_name] db_backup.dump