Backup/Restore PostgreSQL Database

backup_restore.sh

# List all databases
sudo -u postgres psql --list 

# Create backup file
sudo -u postgres pg_dump [database_name] > dumpl.sql

# Drop the database
sudo -u postgres dropdb [database_name]

# Create a new database
sudo -u postgres createdb [new_databse]

# Restore data from the backup
sudo -u postgres psql [new_database] < dump.sql

#####################################################

# Backup a single table
sudo -u postgres pg_dump --table [table_name] [database_name] > dump.sql

# Restore a single table
sudo -u postgres psql -f dump.sql [database_name]