From the objective of OSS-DB Exam Silver
- Operation and Management - Backup method (how to use various backup commands)
Sample Question
1.17
Choose two correct explanations for the next command. pg_dump - s - U abc - f def ghi
- Connect to the database with super user abc.
- Data in the database is not dumped.
- Dump is output to standard output.
- Table def is dumped.
- Connect to database ghi.
※This sample exam is different from those that appear in the actual OSS-DB Exam.
2019/03/04
Answer and Explanation
pg_dump is a utility to create a database backup.
There are many options, and you can create various backups according to your purpose.
-s is an option to dump only data definitions and not to dump data. This is useful when you want to migrate only the table definition to another database.
-U is an option to specify the user to connect to the database, in this case you will connect with user abc, but it is not necessarily the superuser.
- f is an option to specify an output file, in which case the dump result is output to a file called def. If there is no -f option, it is output to standard output.
You can specify the name of the database to connect to at the end of the command line. In this case, connect to the database called ghi.
Therefore, the correct answers are B and E.