Backup and restore in PostgreSQL using compressed backups.

bash.sh

# List databases
sudo su postgres
psql
\list

# Create a compressed backup
sudo su postgres
pg_dump -Fc <database_name> > <file>

# Example
pg_dump -Fc geartranslations_development > /tmp/backup.dump


# Restore a plain-text backup
# TABLES THAT ALREADY EXIST WILL NOT BE MODIFIED.
sudo su postgres
pg_restore -Fc -d <database_name> <backup_file>

# Example
pg_restore -Fc -d geartranslations_development /tmp/backup.dump