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

EnterpriseDB PostgreSQL-Essentials Exam - Topic 6 Question 18 Discussion

Posted by Selma on Jul 16, 2026 at 12:40 PM

You need to restore only the schema from a custom format backup file. Which pg_restore option should you use?

Suggested Answer: D

Get Premium PostgreSQL-Essentials Questions as Interactive Web-Based Practice Test or PDF Real Exam Format Detailed Explanations Instant Access Get Your Practice Test
12 comments · newest first
LA
Lanie 1 month ago
What about D? Both B and C could be right.
LA
Lashandra 1 month ago
I agree, B makes sense for schema restoration.
AR
Arleen 1 month ago
I think it's B, --schema-only.
ST
Stephanie 2 months ago
I thought it was A) --data-only at first.
LA
Lauran 2 months ago
I agree with Richelle, B is the way to go!
DE
Deeanna 2 months ago
Wait, is it really just B? Sounds too simple.
NO
Novella 2 months ago
I think D) Both B and C makes sense too!
RI
Richelle 2 months ago
Definitely B) --schema-only.
SH
Sheron 2 months ago
I’m leaning towards D because it seems like both B and C could be correct for restoring the schema.
VA
Valentin 3 months ago
I feel like I might confuse the data-only and schema-only options. Wasn't there a question that had similar choices?
EL
Eleonore 3 months ago
I remember practicing a question about pg_restore options, and I think both B and C refer to schema-only restoration.
SO
Son 3 months ago
I think the option for restoring just the schema is --schema-only, but I'm not completely sure.
0/2000 characters

Save Cancel