pgSimload v.1.4.8 released today. It's just a maintenance release to upgrade underlying modules:
- built with Go 1.24.5
- dependencies upgrades:
- golang.org/x/crypto => v0.40.0
- golang.org/x/sys => v0.34.0
- golang.org/x/text => v0.27.0
github.com/CrunchyData/...
I'm happy to share that I'm starting a new position as **Senior Solution Engineer** at ❄️ Snowflake ❄️.
Very excited to bring some Elephants to the snow park! <3
pgSimload v.1.4.7 monthly build released!
Built with Go 1.24.3, dependencies upgrades:
- toolchain => go1.24.3
- github.com/jackc/pgx/v5 => v5.7.5
- golang.org/x/crypto => v0.38.0
- golang.org/x/sys => v0.33.0
- golang.org/x/text => v0.25.0
github.com/CrunchyData/...
@crunchydata.com will be present at PG Day France (pgday.fr) at Mons, Belgium ;-)
@karenhjex.bsky.social will present "Postgres sur Kubernetes pour le DBA réticent"
@louisemeta.bsky.social will present "Voyage au centre des statistiques dans Postgres"
Come and share #PostgreSQL love with us!
@crunchydata.com : leading by innovation !
Logical Replication from Postgres to Iceberg: **marked as DONE**
www.crunchydata.com/blog/logical...
pgSimload v.1.4.6 released today. It's just a maintenance release to upgrade underlying modules:
upgraded crypto to v0.37.0
upgraded sys to v0.32.0
upgraded text to v0.24.0
upgraded jackc/pgx/v5 to v5.7.4
github.com/CrunchyData/...
Call of paper is still open at PGDay Fr 2025! Talks can be in English this year... And this will take place in Mons, Belgium, early June. Because PostgreSQL Fr is not about France, it's a recognized NPO about both French speaking countries and PostgreSQL ;-)
See you there!
pgday.fr/apropos
pgSimload v.1.4.5 released today. A good number of minor changes, including better compiled binaries.
More info on github.com/CrunchyData/...
-[ 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
2/ watch the psql exec of that query
watch -n 1 psql -x -f /tmp/query.sql
(3/..)
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/..)
You need to inspect correctly WALs activities in a PG container in a quick, elegant and efficient way?
This is a solution I propose, with some FILTER love embedded.
(post 1/..)
+1
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: two directories I refresh a lot this morning:
Status of video encoding/publishing:
review.video.fosdem.org/overview
Videos actually online:
video.fosdem.org/2025/
Karen Jex and Magnus Hagander introducing FOSDEM PGDay 2025 on stage
#FOSDEMPGDay the #FOSDEM fringe event dedicated to #Postgres is kicking off with an introduction by #PostgreSQL Europe board members @karenhjex.bsky.social and @magnus.hagander.net!
#OpenSource #Database #PGDay
Flashback to when I was teaching a DB Intro class that was in Oracle by decree from the lecturer, and it was so obvious I hated it that in the end-of-semester student eval I found, no joke, "please just let him use Postgres it's too painful"
Looks like @golang.org 1.24 is going to be pretty epic!
Weak pointers, properly working finalizers alone might change the game! Then optimized maps, native fake clock, benchmarking reliability and ease of use, and tooling dependency management.. and more!
antonz.org/go-1-24/
pgSimload 1.4.4 is out:
- monthly rebuild with dependencies updates
- a small output bug in Patroni Watched mode with one unique instance
Please update your binary by downloading it there:
github.com/CrunchyData/...
I tried to write a blogpost for #PostgreSQL newcomers, with some tips and hints of things to think about or do right from the start for any new project. Interested by your feedback:
blog.argudo.org/posts/newpro...
Twitter/X account closed. I planned to do that yesterday but... I didn't find time to, and then, forget to do it. One good thing done for today!
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 :-(
I think a #PostgreSQL DBA can't never be too far from infrastructure components. Today this means *also* Kubernetes, "DevOps" and so on... What's your opinion? The last article on my blog about my home lab could be a good illustration : blog.argudo.org/posts/homelab/
This is 🤩 💯
PgBouncer 1.24.0 is out, with many improvements. And prepared statement support is now turned on by default! github.com/pgbouncer/pg...
Oui! je vois partout des posts pour faire en sorte que W10 puisse migrer à W11 (ou pas)... Ou éviter qu'outlook ne se mette à jour, etc. Mieux vaut passer sous Linux! Certes il faudra faire des efforts, et apprendre un peu (lire des docs surtout). Mais l'investissement est très vite rentabilisé !
Sharing some thoughts about PostgreSQL on Kubernetes...
What are yours ?
blog.argudo.org/posts/kubern...
I did a pgSimload rebuild release v.1.4.3 by today.
Fixes a flaw the x/crypto/ssh go library (CVE-2024-45337)
github.com/CrunchyData/...
So I've started a blog. I hesitated *a lot* before doing this. But I've been asked again at PostgreSQL Conference Europe 2024 in Athen by someone rather young (half my age) to write my journey in the PostgreSQL Community, so I did. Feel free to read or not to read, it's a blog :-)
blog.argudo.org
