Discuss PostgreSQL PGCES-02 Exam Topic 8 Question 99

Select two suitable statements regarding the pg_dump command.

Apg_dump is an SQL command.

BOnly the user who executed initdb can execute pg_dump.

Cpg_dump can create a backup while postmaster is running.

Dpg_dump can create a backup while postmaster is stopped.

Epg_dump can create a backup of a specified table.

Suggested Answer: C, E

Get Premium PGCES-02 Questions as Interactive Web-Based Practice Test or PDF Real Exam Format Detailed Explanations Instant Access Get Your Practice Test

24 comments · newest first

Gail 2 days ago

I hope I get this right. It's tricky!

Sunny 7 days ago

Yes! C and E are the safest choices.

Elliot 12 days ago

Exactly! Only the initdb user restriction is confusing.

Loreen 17 days ago

Right! It's more of a utility. B seems wrong too.

Gail 22 days ago

I feel A is misleading. pg_dump isn't just an SQL command.

Sunny 28 days ago

Agreed! C is definitely right. E makes sense too.

Elliot 1 month ago

I think C and E are correct. pg_dump works while postmaster is running.

Myrtie 1 month ago

I remember using pg_dump for specific tables. E is spot on!

Lenna 1 month ago

Same here! C is crucial for live backups.

Gregoria 2 months ago

I feel confident about C and E. They align with my experience.

Margurite 2 months ago

Right, it's a utility. B is definitely wrong too.

Amber 2 months ago

A is misleading. pg_dump isn't an SQL command itself.

Steffanie 2 months ago

E is also valid. You can back up specific tables.

Bette 2 months ago

Agreed! C makes sense since it can run while postmaster is active.

Samira 2 months ago

I think C and E are correct.

Claribel 3 months ago

I doubt only the initdb user can run pg_dump. Sounds off.

Laurel 3 months ago

You can back up specific tables too, right? That's awesome!

Stephanie 3 months ago

Wait, is pg_dump really an SQL command? I thought it was a utility.

Truman 3 months ago

Totally agree, it's super handy for live backups!

Colene 3 months ago

pg_dump can create a backup while postmaster is running.

Josefa 4 months ago

I’m confused about B; I thought anyone with the right permissions could run pg_dump, not just the initdb user.

Kara 5 months ago

I practiced a question like this, and I believe pg_dump can back up specific tables, so E might be right.

Cruz 5 months ago

I think pg_dump can work while the postmaster is running, but I'm not entirely sure about the specifics.

Jin 5 months ago

I remember pg_dump is definitely not an SQL command, so A seems wrong.

PostgreSQL PGCES-02 Exam - Topic 8 Question 99 Discussion