bramaudi

postgresql

 ·  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