Discuss PostgreSQL PGCES-02 Exam Topic 4 Question 100

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

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

22 comments · newest first

Demetra 2 days ago

I think it's D. Seems straightforward.

Gail 7 days ago

I think it's D. Seems straightforward.

Fannie 12 days ago

I agree with Matt. D is the best choice here.

Cordelia 17 days ago

E is definitely not it. That's for resetting logs.

Cortney 22 days ago

C is confusing. Why use pg_dump for restore?

Jolanda 28 days ago

B looks wrong. You can't restore with pg_dump.

Claudio 1 month ago

I feel like A might be right. It uses pg_restore.

Matt 1 month ago

I think it's D. Seems straightforward.

Billy 1 month ago

E) sounds sketchy, I wouldn't trust that one at all.

Georgeanna 2 months ago

Wait, can you really use pg_dump for restoring?

Ria 2 months ago

No way, A) is definitely correct!

Louvenia 2 months ago

I think D) is actually the correct one.

Theodora 2 months ago

A) is the right command for restoring a dump.

Lashawna 2 months ago

C) doesn’t even make sense, lol.

Ezekiel 2 months ago

I’m not sure about B), seems off to me.

Latosha 3 months ago

Wait, isn't E) a dangerous command?

Elenore 3 months ago

I think D) is actually the correct one.

Diego 3 months ago

A) is the right command for restoring!

Lindsey 3 months ago

I definitely remember that pg_restore is the tool for restoring, so it has to be one of the options that includes it.

Christene 3 months 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.

Jennie 4 months ago

I remember practicing with pg_dump and pg_restore, but I can't recall if we used -f for restoring.

Ernest 5 months ago

I think the command should start with pg_restore, but I'm not entirely sure which option it is.

PostgreSQL PGCES-02 Exam - Topic 4 Question 100 Discussion