Related

Backup Database

psql

Create a backup of a PostgreSQL database

Connect to PostgreSQL

psql

Connect to a PostgreSQL database using psql

Create Database

psql

Create a new PostgreSQL database

psql/restore-db

Restore Database

Restore a PostgreSQL database from a backup file

restore

Command

psql -U username dbname < backup.sql

Explanation

Restores a PostgreSQL database from a SQL dump file.

Examples

Restore database from file

psql -U postgres mydb < mydb_backup.sql

More

Drop Database

psql

Delete a PostgreSQL database

List Tables

psql

Show all tables in the current database

Restore Snapshot

elasticsearch

Restore index from snapshot