EnterpriseDB PostgreSQL-Essentials Exam - Topic 9 Question 10 Discussion

Actual exam question for EnterpriseDB's PostgreSQL-Essentials exam

Question #: 10
Topic #: 9

[All PostgreSQL-Essentials Questions]

Which utility is used to take a backup of all databases in a PostgreSQL cluster including roles and tablespaces?

Apg_dump

Bpg_dumpall

Cpg_backup

Dpg_clusterbackup

Show Suggested Answer

Suggested Answer: B

by Jacquline at Mar 07, 2026, 06:04 PM

Limited Time Offer

25%

Off

Get Premium PostgreSQL-Essentials Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Denise

15 days ago

Wait, is pg_backup even a thing?

upvoted 0 times

...

Rodrigo

20 days ago

I thought it was pg_dump, but I guess not.

upvoted 0 times

...

Lavonne

25 days ago

It's pg_dumpall for sure!

upvoted 0 times

...

Aleta

1 month ago

Yeah, pg_dumpall includes roles and tablespaces, no doubt!

upvoted 0 times

...

Norah

1 month ago

Wait, are you sure about that? Sounds too easy.

upvoted 0 times

...

Stefanie

1 month ago

pg_dumpall is the way to go!

upvoted 0 times

...

Minna

2 months ago

I thought pg_dump was the right one?

upvoted 0 times

...

Venita

2 months ago

It's definitely pg_dumpall for backing up everything.

upvoted 0 times

...

Marva

2 months ago

I’m a bit confused; I thought pg_backup was a thing, but I don’t recall it being mentioned in our materials.

upvoted 0 times

...

Florinda

2 months ago

I practiced a similar question last week, and I believe pg_dumpall is definitely the right choice for backing up all databases in a cluster.

upvoted 0 times

...

Francene

2 months ago

I’m not entirely sure, but I feel like pg_dumpall is the one that includes roles and tablespaces.

upvoted 0 times

...

Elmer

2 months ago

I think the answer might be pg_dump, but I remember something about pg_dumpall being used for backing up everything.

upvoted 0 times

...