MENU
Which utility is used to take a backup of all databases in a PostgreSQL cluster including roles and tablespaces?
Suggested Answer: B
Get Premium PostgreSQL-Essentials Questions
as Interactive Web-Based Practice Test or PDF
Real Exam Format
Detailed Explanations
Instant Access
Get Your Practice Test
26 comments · newest first
ED
Edna
1 month ago
Definitely B) pg_dumpall. It's the right choice for full backups.
PA
Paola
1 month ago
I was torn between A and B, but B is more comprehensive.
JO
Josefa
2 months ago
Yeah, I agree! It includes roles and tablespaces too.
LA
Lashawna
2 months ago
I think it's B) pg_dumpall. It backs up everything.
CA
Carrol
2 months ago
pg_dump is good, but it doesn't do roles. B is the best option!
SO
Sophia
2 months ago
I was torn between A and B, but B is definitely more comprehensive.
RO
Rosendo
2 months ago
Agreed! pg_dumpall is the right choice. Covers roles too.
HA
Hana
2 months ago
I think it's B) pg_dumpall. It backs up everything.
PA
Paz
3 months ago
Definitely B. It’s essential for full cluster backups!
LI
Lino
3 months ago
I was torn between A and B, but B seems more comprehensive.
JO
Josphine
3 months ago
Agreed! pg_dumpall is the right choice. Covers roles too.
TR
Troy
3 months ago
I think it's B) pg_dumpall. It backs up everything.
SH
Shawana
3 months ago
I’m surprised there’s no pg_clusterbackup option!
SY
Sylvia
4 months ago
Totally agree, pg_dumpall is the right choice!
DE
Denise
5 months ago
Wait, is pg_backup even a thing?
RO
Rodrigo
5 months ago
I thought it was pg_dump, but I guess not.
LA
Lavonne
5 months ago
It's pg_dumpall for sure!
AL
Aleta
6 months ago
Yeah, pg_dumpall includes roles and tablespaces, no doubt!
NO
Norah
6 months ago
Wait, are you sure about that? Sounds too easy.
ST
Stefanie
6 months ago
pg_dumpall is the way to go!
MI
Minna
6 months ago
I thought pg_dump was the right one?
VE
Venita
6 months ago
It's definitely pg_dumpall for backing up everything.
MA
Marva
6 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.
FL
Florinda
7 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.
FR
Francene
7 months ago
I’m not entirely sure, but I feel like pg_dumpall is the one that includes roles and tablespaces.
EL
Elmer
7 months ago
I think the answer might be pg_dump, but I remember something about pg_dumpall being used for backing up everything.