※This sample exam is different from those that appear in the actual OSS-DB Exam.
To create a base backup for use with PITR or streaming replication,
(1) Connect as an administrator user to the database and execute select pg_start_backup ()
(2) Create a physical copy of the entire database cluster using OS commands such as tar,
(3) Connect as an administrator user to the database and execute select pg_stop_backup ()
We will carry out the three steps. In PostgreSQL 9.1 and later, you can execute these three steps collectively and automatically by executing the pg_basebackup command.
It is a logical backup of the database that can be created with pg_dumpall, it can not be a base backup of PITR. The cold backup acquired after stopping the database with pg_ctl stop is also important for the operation management of the database, but it is not a base backup of PITR.
Therefore, the correct answers are B and D.