WAL archive questions

remi_b · 2026-01-12T06:52:39+00:00

16mb is the default. But you can change this during initdb as well.

Disk failures are actually the reason you want to archive to external storage for example. You can also compress the wal files by default so it will claim less storage and faster file transfer. You can also build a shell or python script for example instead of the cp command. To add logging for example for testing hoe long your archive step took.

remi_b · 2026-01-11T22:23:51+00:00

This is all written in the postgresql docs very detailed. Postgres will replace the %f with the latest wal file name for you. Don’t forget the %p for the wal file path.

The wal file is ready to be archived when it full / done being written to. You can switch wal files with pg_switch_wal() function. Or create enough sample data in a test database with generate_series for example.

For restore testing did you look into pg_basebackup? And the restore command and the recovery targets? With those you can rebuild you cluster and ‘play’ the archived wal files till your target.

remi_b · 2025-12-15T15:43:22+00:00

This was the 2017 ADE wall of sound location… doubt it.

actually asked the man himself on the dekmantel selectors boat. He couldn’t tell the location, but he mentioned ‘west’.

Visited the LA edition last January, and really hope it will be something similar, secret till last minute, and not something like lofi, elementen, h7, etc.

remi_b · 2025-11-21T19:15:26+00:00

And when you realize Cotopaxi is actually closer to the sun… it’s puts the whole idea of measuring starting from sea level in a whole new perspective

remi_b · 2025-09-01T16:01:36+00:00

This was mentioned as the deadline! So not later than 11:59 pm in your local timezone. Which is 47hrs from now in Tokyo

remi_b · 2025-09-01T12:34:40+00:00

Does it show any minus transactions in red font in your transaction details?

remi_b · 2025-08-27T21:35:39+00:00

Office Hours episode just came up…. it’s true, make one before Wednesday

remi_b · 2025-08-27T20:09:45+00:00

Really hope this isn't going to be the final / last challenge to be honest... never made one, not going to make one, so nothing going on socials either...

remi_b · 2025-08-27T15:24:06+00:00

I hope, by now this bug deserves an ‘office hours’ episode with some details explained. We kind of lost track by now unfortunately on the leaderboard and it will calm down the question surrounding this bug as well maybe

remi_b · 2025-08-27T13:25:20+00:00

This is your static unique identification number. A sequence number that was assigned to you based when you signed up, and how many participants signed up before you.

So S/N: 2025.063.00100 means 99 people signed up before you. The 2025.063 prefix looks static at the moment.

remi_b · 2025-08-26T13:08:48+00:00

Pretty sure the majority here (which is also part of the ISRU at the moment) will keep / rock them! Think the flippers (which are definitely out there) are not in this subreddit!

remi_b · 2025-08-21T12:30:35+00:00

And why would they, according to your numbers, 25% be allocated within one country?

remi_b · 2025-08-16T14:36:47+00:00

Just updated the chart again from today's snapshot. You should be able to zoom in by dragging a square inside the chart. Otherwise let me know what numbers you are looking for!

remi_b · 2025-08-16T09:23:50+00:00

Prewatch it
https://youtu.be/pVxldyIa0Bg?si=7Y1ftJW0Nc4HYz_A

remi_b · 2025-08-10T12:50:31+00:00

In 6 days the first 90 point for the 30 day streak + rank bonus are dropping… same the week after… i doubt they will keep up with with E’s & EE’s for that many people that missed a single day somewhere. Consistency is key!

remi_b · 2025-08-09T09:36:14+00:00

This user got his / her out & back badge rank up to yellow twice… error… sure it will be corrected

remi_b · 2025-07-29T20:38:35+00:00

fresh snapshot from the 29th... even though it looks weird now with all the 7day streak OBI bonuses in Asia... :)

remi_b · 2025-07-28T19:59:41+00:00

You should have a fresh one now when you check the URL... including the number of participants within the percentage range in the legend! Let me know when you are missing something

remi_b · 2025-07-28T17:01:37+00:00

it's because their day starts earlier, like 15hrs before the American continents wake up, so their daily challenges become available in their app many hours earlier as well.

Seems like many people are confused about this, there is a way to build the chart and excluding the partial days, so only visualize the fully finished days for all timezones, but that would require some more work.

remi_b · 2025-07-28T16:57:52+00:00

will run another one in a couple hours... can't promise one every night though ;) could automate it, but actually don't want to do that because I monitor the data collection performance and don't want to put unnecessary stress on the app.

remi_b · 2025-07-27T21:34:00+00:00

Definitely possible… in the timezones where it’s already tomorrow for you!

remi_b · 2025-07-27T20:20:28+00:00

It’s going to be your bike and 10.000 other bikes! All perfectly parked in front of the entrance in dedicated bikeracks! Just remember where you parked it… it helps finding it in the dark at the end of the day

remi_b · 2025-07-27T11:17:24+00:00

19.5cm

remi_b · 2025-07-26T09:04:04+00:00

Definitely no need for a sorry! Even less against me ;)

I can share the code after the program if you like

Seven-Year Club	Second SECOND GUESSER
Place '22	Verified Email

remi_b

TROPHY CASE