Question
How to Backup PostgreSQL Database from Command Line
Solution
Postgresql comes with two utilities called ‘pg_dump and ‘pgsql’. These can be used to backup and restore database.
To backup postgresql database using command line, you can use this:
pg_dump database_name > database_name.sql
This would take the backup and store it in .sql file.
To restore postgresql (.sql) file to a database using command line, you can use this:
pgsql database_name < database_name.sql