MENU
I want to restore data from a text format backup file foo.dump. Select an appropriate command.
Suggested Answer: D
Get Premium PGCES-02 Questions
as Interactive Web-Based Practice Test or PDF
Real Exam Format
Detailed Explanations
Instant Access
Get Your Practice Test
14 comments · newest first
NA
Na
10 months ago
Just to clarify, is foo.dump really a text format?
ME
Merissa
10 months ago
I agree, pg_restore is definitely the way to go!
TE
Tess
10 months ago
B is the right command for restoring from a dump file.
LU
Luke
10 months ago
Wait, are we sure about that? I thought psql could do it too.
OM
Omega
10 months ago
A and E are definitely wrong.
HE
Helene
11 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.
KI
Kip
11 months ago
I feel like pg_dump is for creating backups, not restoring them, so I don't think option A is correct.
CA
Candra
11 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?
SH
Shelia
11 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.
MA
Marti
12 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.
WI
Winfred
12 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.
KA
Karon
12 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.
MA
Man
1 year 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.
RI
Rikki
1 year ago
I think the answer is B. pg_restore is the command used to restore a database from a backup file.