Jean-Paul Argudo
banner
jpargudo.bsky.social
Jean-Paul Argudo
@jpargudo.bsky.social
PostgreSQL fan and advocate, since 2000. Founding member of PostgreSQLFr, PostgreSQLEu and Dalibo. Started Crunchy Data France in 2022! Opinions are my own here
-[ RECORD 1 ]--
wals_done | 10
wals_ready | 0

-[ RECORD 1 ]--+-
archived_count | 641
last_archived_wal | 00000001000000020000007C
last_archived_time | 2025-02-12 07:19:41.553684+00
failed_count | 0
last_failed_wal |
last_failed_time |
stats_reset | 2025-02-10 11:03:18.025733+00
February 12, 2025 at 7:28 AM
2/ watch the psql exec of that query

watch -n 1 psql -x -f /tmp/query.sql

(3/..)
February 12, 2025 at 7:28 AM
1/ create a /tmp/query.sql with

select count(*) filter (where pg_ls_dir~'done') as wals_done, count(*) filter (where pg_ls_dir~'ready') as wals_ready from pg_ls_dir('pg_wal/archive_status');
select * from pg_stat_archiver;

(2/..)
February 12, 2025 at 7:28 AM
+1
February 6, 2025 at 2:29 PM
Marcin Juszkiewicz is maintaining that page too, updated every 2h and with a search box ! Thanks to him!

gpages.juszkiewicz.com.pl/fosdem-videos/
FOSDEM 2025 schedule with links to slides and videos
Alternative view for FOSDEM schedule. With direct links to slides and video files (where available).
gpages.juszkiewicz.com.pl
February 3, 2025 at 2:19 PM
Je suis toujours étonné de voir combien de fois ça m'arrive encore... et encore. Et pourtant, c'est pas comme si ça faisait 30 ans que j'envoyais des mails :-(
January 13, 2025 at 1:05 PM