Backup restore

10 points

This is a good place to start your h^ adventure.

Your task is simple. Connect to the problem endpoint and grab a PostgreSQL database dump. It's going to be base64 encoded, because bytes.

We want you to restore that backup on a Postgres server of your choosing and extract the social security numbers of people marked as alive. The others are of no concern to us. Things should be clearer once you get to know the structure of the DB.

Submit the correct list of SSNs to the solution endpoint and grab your reward.

Getting the problem set

GET /challenges/backup_restore/problem?access_token=...

Problem JSON structure is simple:

  • dump: a base64 encoded pg_dump dump (by the way, -Z9)

Submitting a solution

POST /challenges/backup_restore/solve?access_token=...

Your solution should be a JSON with the following keys inside it:

  • alive_ssns: a list of SSNs corresponding to entries marked with a status of alive. Order does not matter, the list is treated as a set internally.

Background

It's amazing how many people can't restore a backup! Don't be one of them.


By the way, I'd love to hear from you. Whatever you got, drop me an email. My h^ profile is here.
Starting not that long ago, you can also support this website by buying me a coffee. Thanks!
RSS: full changelog, challenges – stay up to date, grab a world first, maybe?
Check out my little newsletter, Becoming a Better Developer, it's pretty OK.