Deal of The Day! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions
Mail Us support@pass4success.com
Location US
Mob_nav_barsMENU

PostgreSQL PGCES-02 Exam - Topic 4 Question 100 Discussion

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)
D) psql -U postgres -f db1.dump db1
A) pg_restore -U postgres -f db1.dump db1
B) pg_dump --restore db1 < db1.dump
C) pg_dump -U postgres --restore db1 < db1.dump
E) pg_resetxlog -U postgres db1 < db1.dump

PostgreSQL PGCES-02 Exam - Topic 4 Question 100 Discussion

Actual exam question for PostgreSQL's PGCES-02 exam
Question #: 100
Topic #: 4
[All PGCES-02 Questions]

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)

Show Suggested Answer Hide 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:

0/2000 characters
Submit Cancel
Diego
A) is the right command for restoring!
upvoted 0 times
...
Lindsey
5 days ago
I definitely remember that pg_restore is the tool for restoring, so it has to be one of the options that includes it.
upvoted 0 times
...
Christene
10 days ago
I feel like option D might be the right choice since psql is often used for executing SQL commands, but I'm not completely confident.
upvoted 0 times
...
Jennie
15 days ago
I remember practicing with pg_dump and pg_restore, but I can't recall if we used -f for restoring.
upvoted 0 times
...
Ernest
2 months ago
I think the command should start with pg_restore, but I'm not entirely sure which option it is.
upvoted 0 times
...

Save Cancel