DBA's Avatar

DBA

@pgdba.bsky.social

DB Specialist @Veeam, Ex-@Wise drunkdba.medium.com https://github.com/secp256k1-sha256/tenxdev

103 Followers  |  109 Following  |  78 Posts  |  Joined: 18.11.2024  |  2.1804

Latest posts by pgdba.bsky.social on Bluesky

Preview
Oracle attempt to hide serious cybersecurity incident from customers in Oracle SaaS service Being a provider of cloud SaaS (Software-as-a-service) solutions requires certain cybersecurity responsibilities — including being…

If this ends up being true, and I struggle to see how it won’t, this is a very very bad look. Trying to “wordsmith” your way out of a breach will not pay off, you may think it will but it will burn you. You don’t need graphic detail but you do need honesty

doublepulsar.com/oracle-attem...

31.03.2025 13:07 — 👍 52    🔁 17    💬 3    📌 3
Post image

Devrim from EDB is giving us a lightning talk about 75 slides long

#postgresql #database #copenhagen

18.03.2025 15:49 — 👍 3    🔁 2    💬 0    📌 0

Yesterday we published our open-source Xata agent to help everyone get better at managing their Postgres databases. Let me know what you think!

And @simonwillison.net has already tried it and shared his feedback 👇🏽

14.03.2025 08:58 — 👍 6    🔁 2    💬 0    📌 0

It's probably cause native backup options are not as robust as 3rd Party (pgbackrest,barman). As an Oracle DBA we were always expected to know and use built-in RMAN backup. I observe Postgres users to be relatively casual about backups.

12.03.2025 13:54 — 👍 1    🔁 0    💬 0    📌 0
Post image

supabase web traffic has surpassed mongodb

04.03.2025 12:20 — 👍 16    🔁 4    💬 0    📌 1
A tale about (incomplete) upgrade from PostgreSQL 12 to 14 – select * from depesz;

Depesz article lists most problems in setting up logical replica at scale. Apart from these "initial sync snapshot too large" is also common at large size.

www.depesz.com/2023/06/04/a...

28.02.2025 22:40 — 👍 1    🔁 0    💬 1    📌 0

Pg_upgrade with link mode or clone option is not that painful, it's preparing logical replica that's most time consuming and full of nightmare part.

28.02.2025 22:32 — 👍 1    🔁 0    💬 1    📌 0
Post image

I assumed it would be via bidirectional logical replication. So it's not using postgres logical replication protocol?

28.02.2025 20:00 — 👍 1    🔁 0    💬 1    📌 0

What's the largest cluster have you upgraded using this method? Logical replication is PITA at >10TB size and >10K tables.

28.02.2025 19:15 — 👍 1    🔁 0    💬 1    📌 0
PCI

Update: In response to a trademark notice from the PostgreSQL Community Association of Canada, domain has been changed from “Postgres.Is” to pgscorecard.com

28.02.2025 09:16 — 👍 0    🔁 0    💬 0    📌 0

Update: In response to a trademark notice from the PostgreSQL Community Association of Canada, domain has been changed from “Postgres.Is” to pgscorecard.com

28.02.2025 09:16 — 👍 0    🔁 0    💬 0    📌 0
Post image

EDB Says It Tops Oracle, Other Databases in Benchmarks EDB Postgres AI, the latest PostgreSQL-bas...

https://www.bigdatawire.com/2025/02/19/edb-says-it-tops-oracle-other-databases-in-benchmarks/

#News #in #Brief #database #database #benchmark #EDB #Postgres #AI #mongodb #MySQL

Event Attributes

20.02.2025 00:05 — 👍 1    🔁 1    💬 0    📌 0
Preview
EDB Postgres® AI Significantly Outperforms Oracle, SQL Server, MongoDB, and MySQL in New Benchmark Study Independent study from McKnight Consulting Group shows EDB Postgres AI as the fastest, most cost-effective enterprise database platform for transactional, analytical, and new AI workloads

EDB Postgres® AI Significantly Outperforms Oracle, SQL Server, MongoDB, and MySQL in New Benchmark Study https://buff.ly/3ENQL35 via @MichaelGale of EDBPostgres on @Thinkers360 #Business #Services #Technology

23.02.2025 17:09 — 👍 1    🔁 1    💬 0    📌 0

What's the point of being rich if you can't afford to do the right thing.

13.01.2025 16:29 — 👍 27699    🔁 4194    💬 745    📌 242
Installing PostgreSQL Extensions via RPMs - PostgreSQL YUM Repository

Hello, #PostgreSQL community!

I’m excited to introduce a new community project: "Installing and Configuring PostgreSQL Extensions via RPMs"!

yum.postgresql.org/extensions/

21.02.2025 08:15 — 👍 9    🔁 6    💬 1    📌 0
Post image

HYTRADBOI ("Have you tried rubbing a database on it?", @hytradboi.bsky.social) is happening again! It's a really cool, forward-looking online event on everything databases. Highly recommend to check it out and attend. Happening on Feb 28, 9:00-15:00 PDT.

www.hytradboi.com/2025

18.02.2025 13:34 — 👍 26    🔁 7    💬 0    📌 2
Post image

Our Postgres in WASM project, @pglite.dev, has hit 1/2 million downloads a week! 🤯
We (@electric-sql.com) have a lot planned for (native... 😉) PGlite this year, exciting times ahead!

10.02.2025 10:55 — 👍 46    🔁 7    💬 1    📌 2

Great idea! I always wondered how all these DB platforms could implement full Postgres compatibility and assumed it was mostly T-SQL syntax and enough auth + config support to use a standard Postgres JDBC / ODBC driver.

17.02.2025 08:51 — 👍 1    🔁 1    💬 0    📌 0

So many databases claim to be compatible with #Postgres these days, but what does that really mean? @pgdba.bsky.social tries to provide an objective answer with the Postgres Compatibility Index, which verifies compatibility in a wide range of criteria. Loving to see this effort!

17.02.2025 08:14 — 👍 20    🔁 4    💬 0    📌 0

Leveling up! Sleek new web app for the Postgres Compatibility Index is live. Big thanks to Contributors: @gunnarmorling.dev , @tudor.golubenco.org , Frank Pachot, Deepak Mahto , Matt Cornillon and Akash.

Postgres.Is 🚀✨ 🐘

Blog => tinyurl.com/3wr3vy5x

17.02.2025 04:37 — 👍 17    🔁 9    💬 3    📌 3

Leveling up! Sleek new web app for the Postgres Compatibility Index is live. Big thanks to Contributors: @gunnarmorling.dev , @tudor.golubenco.org , Frank Pachot, Deepak Mahto , Matt Cornillon and Akash.

Postgres.Is 🚀✨ 🐘

Blog => tinyurl.com/3wr3vy5x

17.02.2025 04:37 — 👍 17    🔁 9    💬 3    📌 3
Post image

Breaking (most oltps) :
Drumpf to impose 100% tarrif on Foreign Keys.

Source : TrustMeBro Inc™️

16.02.2025 15:46 — 👍 1    🔁 1    💬 0    📌 0
Post image

Breaking (most oltps) :
Drumpf to impose 100% tarrif on Foreign Keys.

Source : TrustMeBro Inc™️

16.02.2025 15:46 — 👍 1    🔁 1    💬 0    📌 0
Bio pic of Talking Postgres podcast guest & PostgreSQL committer Robert Haas who joined for Episode 24 to talk about mentoring in PostgreSQL

Bio pic of Talking Postgres podcast guest & PostgreSQL committer Robert Haas who joined for Episode 24 to talk about mentoring in PostgreSQL

New episode of #TalkingPostgres #podcast

#PostgreSQL committer Robert Haas joined to talk about mentoring in Postgres: why it matters, his own experiences, what would Tom Lane do, the new PostgreSQL Hackers Mentoring program, & more

🎧 talkingpostgres.com/episodes/why...

📺 youtu.be/4wSDnx8di6o?...

07.02.2025 18:31 — 👍 8    🔁 3    💬 0    📌 2

And if you're looking to give a #PostgreSQL talk this year, the #CFP (call for proposals) for #PosetteConf is still open until Sunday Feb 9 at 11:59pm PST!

Carpe diem, what Postgres database 🐘 stories & expertise & experiences do you want to share?

Boosts appreciated, so more ppl are reminded 🚀

29.01.2025 20:47 — 👍 5    🔁 5    💬 2    📌 0

Looking forward to postgres core development, patch process and extension dev related talks. Especially those targeting future postgres commiters.

30.01.2025 12:46 — 👍 1    🔁 0    💬 0    📌 0

Do you have a spot in Feb or March? I am thinking of creating website for it and publish results of all major Postgres derivatives.

30.01.2025 10:56 — 👍 1    🔁 0    💬 1    📌 0
Post image

Xata sushi kit, initmax socks, pgstream stickers and Speaker's #postgres coffee cup = A wholesome conference.

#p2d2
#PraguePgDevDay

30.01.2025 10:37 — 👍 0    🔁 0    💬 0    📌 0

idle_in_transaction_session_timeout is more important cause statement timeout can be handled at application level as well.

21.01.2025 09:22 — 👍 0    🔁 0    💬 0    📌 0

@pgdba is following 20 prominent accounts