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 7 Question 83 Discussion

I want to restore data from a text format backup file foo.dump. Select an appropriate command.
D) psql -f foo.dump foo
A) pg_dump -R foo < foo.dump
B) pg_restore -d foo foo.dump
C) pg_restore -f foo.dump foo
E) createdb foo < foo.dump

PostgreSQL PGCES-02 Exam - Topic 7 Question 83 Discussion

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

I want to restore data from a text format backup file foo.dump. Select an appropriate command.

Show Suggested Answer Hide Answer
Suggested Answer: D

by Denny at Mar 18, 2025, 05:52 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
Na
7 months ago
Just to clarify, is foo.dump really a text format?
upvoted 0 times
...
Merissa
7 months ago
I agree, pg_restore is definitely the way to go!
upvoted 0 times
...
Tess
7 months ago
B is the right command for restoring from a dump file.
upvoted 0 times
...
Luke
7 months ago
Wait, are we sure about that? I thought psql could do it too.
upvoted 0 times
...
Omega
7 months ago
A and E are definitely wrong.
upvoted 0 times
...
Helene
8 months ago
I vaguely recall that using psql with the -f flag is the way to go for text format backups, so maybe option D is the right choice.
upvoted 0 times
...
Kip
8 months ago
I feel like pg_dump is for creating backups, not restoring them, so I don't think option A is correct.
upvoted 0 times
...
Candra
8 months ago
I think I practiced a similar question where we had to use psql for restoring from a dump file. That might be option D?
upvoted 0 times
...
Shelia
8 months ago
I remember that pg_restore is used for restoring backups, but I'm not sure if it's the right command for a text format file.
upvoted 0 times
...
Marti
9 months ago
I'm still a bit unsure, but I think I'll go with B. The wording of the question makes me think pg_restore is the right command, and the -d flag to specify the database name seems logical. I'll double-check my notes, but I'm leaning towards B.
upvoted 0 times
...
Winfred
9 months ago
I'm pretty confident that B is the correct answer. The question states we want to restore from a text format backup, and pg_restore is the appropriate command for that. The -d flag to specify the database name also makes sense.
upvoted 0 times
...
Karon
9 months ago
Okay, let's see. The question says we want to restore from a text format backup file, so that rules out A and D since those are for different types of backups. B and C both mention pg_restore, so those seem like the most likely options. I'll go with B since it specifies the -d flag to restore to a database.
upvoted 0 times
...
Man
9 months ago
Hmm, I'm a bit confused. I know we need to restore from a text format backup, but I'm not sure if pg_restore is the right command or not. I'll have to think this through carefully.
upvoted 0 times
...
Rikki
9 months ago
I think the answer is B. pg_restore is the command used to restore a database from a backup file.
upvoted 0 times
...

Save Cancel