New Year Sale 2026! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions
Mail Us support@pass4success.com
Location US
Mob_nav_barsMENU

EnterpriseDB PostgreSQL-Essentials Exam - Topic 4 Question 9 Discussion

Actual exam question for EnterpriseDB's PostgreSQL-Essentials exam
Question #: 9
Topic #: 4
[All PostgreSQL-Essentials Questions]

You want to configure your cluster to run in archive mode for Point-in-Time Recovery. Which parameter must you set in postgresql.conf?

Show Suggested Answer Hide Answer
Suggested Answer: A

by Frederick at Jan 27, 2026, 08:13 PM

Limited Time Offer

25%

Off

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

Contribute your Thoughts:

0/2000 characters
Submit Cancel
Camellia
5 days ago
I remember practicing a similar question, and I believe we also have to specify the `archive_command` to actually store the WAL files.
upvoted 0 times
...
Malcom
10 days ago
I think the parameter we need to set is `archive_mode`, but I'm not entirely sure if there's something else we need to configure as well.
upvoted 0 times
...
Vicki
15 days ago
I'm feeling confident about this one. The parameter you need to set is `archive_mode`. That enables the archive mode for Point-in-Time Recovery, which allows you to restore your database to a specific point in time if needed.
upvoted 0 times
...
Edda
20 days ago
I'm a bit uncertain about this one. I know there are a lot of different parameters in postgresql.conf, and I'm not completely familiar with the ones related to backup and recovery. I'll need to spend some time reviewing that section of the configuration file.
upvoted 0 times
...
Heike
25 days ago
Okay, let me think this through. I know archive mode is related to backups and recovery, so the parameter is likely something like `backup_mode` or `recovery_mode`. I'll have to double-check the documentation to be sure.
upvoted 0 times
...
Claudio
1 month ago
Ah, I know this one! I'm pretty sure the parameter you need to set is `archive_mode`. That should enable the archive mode for Point-in-Time Recovery.
upvoted 0 times
...
Johnetta
1 month ago
Hmm, I think I remember something about a parameter in postgresql.conf for archive mode, but I can't quite recall the exact name. I'll need to review my notes on that.
upvoted 0 times
...

Save Cancel