PostgreSQL Exam PGCES-02 Topic 6 Question 67 Discussion

Actual exam question for PostgreSQL's PGCES-02 exam

Question #: 67
Topic #: 6

[All PGCES-02 Questions]

Select two statements that the command below DOES NOT do.

Note: $ is the command prompt. $ pg_dump -b -F c b > d

ABacks up the 'b' database to the 'c' file, and stores error messages to the 'd' file.

BBacks up the 'b' database to the 'd' file.

CBacks up large objects.

DBacks up the 'c' database to the 'd' file as the 'c' user.

ECreates a backup, which is restorable with the pg_restore command.

Show Suggested Answer

Suggested Answer: A

by Janna at Jul 17, 2024, 04:19 PM

Limited Time Offer

25%

Off

Get Premium PGCES-02 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Andree

13 days ago

I'm just impressed that someone came up with a question that involves both pg_dump and pg_restore. That's a deep cut for a certification exam!

upvoted 0 times

...

Ressie

15 days ago

Whoa, wait a minute. The command is creating a compressed backup, not just dumping the database to a file. Option C must be right, it's backing up the large objects too.

upvoted 0 times

...

Silvana

22 days ago

Hold up, does this command really create a backup that's restorable with pg_restore? That sounds a bit too good to be true. I'll have to double-check the documentation on that one.

upvoted 0 times

...

2 months ago

I think the command does not back up the 'c' database to the 'd' file as the 'c' user.

upvoted 0 times

...