Skip to content

Instantly share code, notes, and snippets.

Embed
What would you like to do?
Backup/Restore PostgreSQL Database
# 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 prostgres 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]
@MrOlek

This comment has been minimized.

Copy link

@MrOlek MrOlek commented Jun 17, 2016

The easiest way to make PostgreSQL backup is to use this tool http://postgresql-backup.com/

@quevon24

This comment has been minimized.

Copy link

@quevon24 quevon24 commented Aug 2, 2016

Thanks, it helped me because other commands that i was trying always displayed some errors, this is the simplest way.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment