# Login
sudo -u postgres psql
# Dump
sudo -u postgres pd_dump dbname > dumpfile
# Restore
sudo -u postgres psql dbname < dumpfile
# Database list
\l
# Quit
\q
· 0 minutes read
# Login
sudo -u postgres psql
# Dump
sudo -u postgres pd_dump dbname > dumpfile
# Restore
sudo -u postgres psql dbname < dumpfile
# Database list
\l
# Quit
\q