Hands-on task
Dump a PostgreSQL database
PostgreSQL is already installed, but the server isn't running. Start it, create a database shopdb with any table (at least one row), and make a logical dump of it into the file /root/shopdb.sql — a plain SQL dump the database can be restored from.
- postgresql
- pg_dump
- sudo -u postgres
- logical dump
- apt