PostgreSQL PGCES-02 Exam - Topic 3 Question 108 Discussion

Question

It is possible to backup a database cluster by copying the entire data directory. Select two suitable descriptions regarding this backup method.

Stephaine · Accepted Answer

B) The database server must be stopped prior to the backup. and E) You can use standard tools like 'tar' and 'rsync' to backup files and directories.

Stephaine · Answer

A) The backup data will be a text file consisting of SQL statements.

Stephaine · Answer

C) The 'pg_restore' command is used to restore the database.

Stephaine · Answer

D) 'psql' is used to restore the database.