Cacher is the code snippet organizer for pro developers

# List databases
sudo su postgres
psql
\list

# Create a plain-text backup
sudo su postgres
pg_dump <database_name> > <file>

# Example
pg_dump geartranslations_development > /tmp/backup.sql


# Restore a plain-text backup
# TABLES THAT ALREADY EXIST WILL NOT BE MODIFIED.
sudo su postgres
psql < <file>

# Example
psql < /tmp/backup.sql