backup

To dump data from a postgreSQL database you can use the pg_dump command as follows pg_dump database > file.sql   To restore that data you can execute the following command psql -d database -f file.sql -U db_username