PostgreSQL PGCES-02 Exam - Topic 4 Question 100 Discussion

Actual exam question for PostgreSQL's PGCES-02 exam

Question #: 100
Topic #: 4

I would like to restore the database cluster from the "db1.dump" backup file. Select the correct command from below. (Note: "postgres" is the superuser)

Apg_restore -U postgres -f db1.dump db1

Bpg_dump --restore db1 < db1.dump

Cpg_dump -U postgres --restore db1 < db1.dump

Dpsql -U postgres -f db1.dump db1

Epg_resetxlog -U postgres db1 < db1.dump

Show Suggested Answer

Suggested Answer: D

by Fernanda at May 17, 2026, 06:34 PM

Limited Time Offer

25%

Off

Get Premium PGCES-02 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Currently there are no comments in this discussion, be the first to comment!