PostgreSQL_CE
PGCES-02 · Question #128
It is possible to backup a database cluster by copying the entire data directory. Select two suitable descriptions regarding this backup method.
The correct answer is B. The database servermust be stopped prior to the backup. E. You can use standard tools like "tar" and "rsync" to backup files and directories.. See the full explanation below for the reasoning.
Question
It is possible to backup a database cluster by copying the entire data directory. Select two suitable descriptions regarding this backup method.
Options
- AThe backup data willbe a text file consisting of SQL statements.
- BThe database servermust be stopped prior to the backup.
- CThe "pg_restore" command is used to restore the database.
- D"psql" is used to restore the database.
- EYou can use standard tools like "tar" and "rsync" to backup files and directories.
How the community answered
(15 responses)- A7% (1)
- B73% (11)
- C7% (1)
- D13% (2)
Community Discussion
No community discussion yet for this question.