PostgreSQL dump and restore database 2020-04-12 03:46
It is easy to dump database by using
You need to switch to
postgres role then execute follow commend to dump your database.
sudo -i -u postgres pg_dump dbname > outfile
After getting dump file, you can use
psql to restore your database.
psql dbname < infile