Data Egret: а significant contributing sponsor of PostgreSQL’s Post

🚀 Automating MongoDB Backups with Bash + Email Notifications 🗄️ Recently, I created a simple yet powerful Bash script that automates the MongoDB schema backup process for Non-Production environments. Here’s what the script does 👇 ✅ Verifies if the MongoDB database exists before taking backup ✅ Performs schema-only mongodump ✅ Logs all activities ✅ Sends a neat HTML-formatted email notification with backup status (✅ Success / ❌ Failure) ✅ Uses msmtp for lightweight email delivery It’s a handy automation for DB admins and DevOps engineers who want to keep things clean and monitored without manual intervention. 💻 Check out the full script on GitHub: 🔗 https://lnkd.in/g72B633Y If you’re working on database or infrastructure automation, would love to hear your thoughts or improvements! 💬 #MongoDB #Bash #Automation #DevOps #DatabaseAdministration #Scripting #Linux #Cloud

Upgrading PostgreSQL: A potentially multi-million dollar decision that doesn't have to happen yet. Your PostgreSQL version is reaching end-of-life. Your team estimates 18 months and significant budget to upgrade across hundreds of databases. Sound familiar? PgLTS from Command Prompt, Inc. extends PostgreSQL support by 3 additional years, giving you eight years total instead of five years. What this means: — Time to plan properly instead of rushing — Budget spread over additional years — FedRAMP compliance maintained — Support for PostgreSQL 12+ Think of it like extending a lease while you plan your next building—except for your database infrastructure. Learn more at https://lnkd.in/gpiMGVam #PostgreSQL #Database #EnterpriseTech #DevOps  #EnterpriseIT

We’re proud of our own Brian Fehrle, DBA & Open Source Advocate, for presenting “Upgrading the Mammoth: Crafting the Best Path to Modernize Your Database” in the Postgres World Webinar Series. Brian shared: - Why outdated databases become “mammoths” and the risks they carry. - Practical strategies for major upgrades, including replication-based approaches. - Lessons learned from real-world client projects at Command Prompt. Watch the full session here: https://lnkd.in/ggCX2Knd #PostgreSQL #CommandPrompt #DatabaseModernization #DatabaseMigration #OpenSourceDatabases #DataArchitecture #DevOps #EnterpriseIT

PostgreSQL 18 is here, and it's a game-changer! 🚀 After diving deep into the new release, I've compiled the top features that every developer, DBA, and tech leader should know about. What's inside this carousel: → Incremental backups (save time & money) → 2x faster JSON operations → Smarter query optimization → Enhanced security features → Better connection scaling Whether you're running a startup or managing enterprise databases, these features will make your life easier. I've included real-world examples and beginner-friendly explanations for each feature, so everyone can understand the impact. Swipe through to learn more! 👉 Which feature are you most excited about? Drop a comment below! 💬 #PostgreSQL #DatabaseManagement #PostgreSQL18 #BackendDevelopment #DevOps #SoftwareEngineering #TechUpdates #CloudComputing #DataEngineering

🚀 New on the DownToZero Blog: Scale-To-Zero PostgreSQL Databases We took our scale-to-zero philosophy one step further — all the way to PostgreSQL. By combining systemd socket activation and Docker Compose, we built databases that only run when needed — saving compute, memory, and cost. Discover how it works, when it shines, and where it doesn’t. 👉 https://lnkd.in/eskvCrAP #PostgreSQL #ScaleToZero #CloudComputing #GreenTech #DowntoZero #DevOps #Sustainability

PostgreSQL 18 may be out, but 16 will be on teams' upgrade paths. From query parallelism and logical replication boosts to enhanced security, this release makes day-to-day DB ops smoother, faster, and safer. We break down the key enhancements and what they mean for your production workloads. Read more: https://buff.ly/y1bII2F #PostgreSQL #DBOps #OpenSource #Performance

EtnaID, a digital identity service, runs PostgreSQL and MySQL with ClusterControl to deliver secure, scalable operations. Automated deployment, monitoring, and failover cut ops overhead while strengthening resilience. https://buff.ly/rneNQyA #DigitalIdentity #PostgreSQL #MySQL #DBOps

🚀 #Day66 of #100DaysOfDevOps — MySQL Deployment on Kubernetes Today, I worked on deploying a MySQL server within a Kubernetes cluster using Persistent Volumes, Secrets, and NodePort Services. The setup involved: 🔹 Defining a PersistentVolume (PV) and PersistentVolumeClaim (PVC) for data persistence. 🔹 Creating Kubernetes Secrets to securely manage credentials (root password, user credentials, and database name). 🔹 Deploying a MySQL container with environment variables mapped from the secrets. 🔹 Exposing it via a NodePort Service for external access. This exercise reinforced how Kubernetes integrates storage management and secret handling to create secure, scalable database deployments. #DevOps #Kubernetes #MySQL #CloudNative #100DaysOfCloud #Containers

Connection Pooling in PostgreSQL 17 — What to use and when? 🚀 Spinning up more DB connections isn’t scaling—it’s thrashing. In my latest post, I break down how connection pooling keeps latency predictable and throughput high in PostgreSQL 17. What’s inside: Why pooling matters: cut connection overhead, smooth traffic spikes, protect max_connections. Options compared: pgBouncer — lightweight, fast; session vs. transaction vs. statement pooling. pgpool-II — pooling plus read load balancing & failover. pgjdbc-ng — in-app pooling for JVM stacks. Quick chooser: Need simple, low-overhead pooling? → pgBouncer Need pooling and read split / HA? → pgpool-II Pure Java and want per-service control? → pgjdbc-ng Takeaway: Picking the right pooler is one of the highest-leverage moves for Postgres performance and scalability. 📢 Stay Updated with Daily PostgreSQL & Cloud Tips! If you’ve been finding my blog posts helpful and want to stay ahead with daily insights on snowflake, AWS, PostgreSQL, Cloud Infrastructure, Performance Tuning, and DBA Best Practices — I invite you to subscribe to my Medium account. 🔔 Subscribe here 👉 https://lnkd.in/gjTTWWKk 🔗 Read the full post: https://lnkd.in/gzwHQbXh Your support means a lot — and you’ll never miss a practical guide again! #PostgreSQL #PostgreSQL17 #Database #DBA #DatabaseAdministrator #Linux #RedHat #RockyLinux #AlmaLinux #OracleLinux #DatabaseInstallation #OpenSource #DevOps #SystemAdministrator #CloudComputing #DataEngineering #DatabaseManagement #ITInfrastructure #CloudDatabase #PostgreSQLInstallation #DatabasePerformance #TechBlog #MediumBlog #Tutorial #PostgresWomenIndia #StepByStepGuide #Learning #CareerGrowth #TechnicalWriting #KnowledgeSharing #MySQL #MSSQL #Mongodb #Oracle #DatabaseSecurity #pg_hba #DataSecurity #Backend #TechWriteUp #DevCommunity #RDS #EC2 #S3, #Aurora #PostgreSQL #PostgreSQL17 #DatabasePerformance #pgBouncer #pgpoolII #JDBC #DevOps #SRE #DBA #Scalability

🚀 Built comprehensive Azure PostgreSQL passwordless authentication samples for Java! Microsoft recommends passwordless authentication as a security best practice. I’ve created two complete implementations with interactive testing to explore both approaches outlined in their guidance: ✅ Zero hardcoded secrets — going fully passwordless ✅ Azure Plugin vs Manual Token comparison 🔍 Explore the guidance: https://lnkd.in/g6BGX6gb 📂 Sample code on GitHub: https://lnkd.in/gaJTQJz8 #Azure #Java #PostgreSQL #Security #Passwordless #CloudDevelopment