In our latest video, Solution Engineer Paul Rothrock demonstrates how pgEdge's Zero Downtime Add Node feature within Spock enables seamless cluster scaling and major version upgrades—without any service interruption.

Scripts to automate this process are available here: https://github.com/pgEdge/spock/tree/main/samples/Z0DAN

Check it out: 👉 https://www.pgedge.com/video/new-feature-highlight-zero-downtime-add-node

All pgEdge software is 100% open source under the PostgreSQL license.

#developers #programming #database #data #tech #technology #opensource #postgresql #postgres

That’s a wrap on the first #PostgreSQL #Edinburgh #meetup! 🐘

Huge thanks to @intrbiz for the talk, @pgEdgeDistributedPostgres for the 🍕, and UoE for the venue.

Slides:
🔹 PG Tricks: https://nexteam.co.uk/files/talks/pg-tricks-postgresedi-meetup.pdf
🔹 RAGtime with #Postgres: https://vyruss.org/computing/slides/postgresedi_ragtime_with_postgres.pdf

We return Feb 12th and need speakers! 🎤 DM/reply if you have a talk idea or feedback!

Happy holidays! 🎄

#TechMeetup #OpenSource #Database

In the final post of the "Building a RAG Server with PostgreSQL" series, learn how to deploy the open-source pgEdge RAG Server for a simple HTTP API you can use to ask questions about your content, and get answers based on your own documentation.

Check it out 👉 https://www.pgedge.com/blog/building-a-rag-server-with-postgresql-part-3-deploying-your-rag-api

Experiment with the RAG Server on #GitHub: https://github.com/pgEdge/pgedge-rag-server

Want to see more of this kind of content? Let us know 💬

#programming #ai #llm #vectordatabase #pgvector #vector #postgresql #postgres #data

Why did we create snowflake sequences when UUIDs exist? ❄️

While they're very similar in purpose, snowflake sequences are more efficient because they encode information like the creation timestamp & the ID of the server that created it in half the size (8 bytes vs. 16 bytes).

They're a huge asset for unique ID management & key generation in distributed databases. Learn more about them here: https://www.pgedge.com/blog/introducing-snowflake-sequences-in-a-postgres-extension-2

#postgresql #postgres #programming #tech #databases #data #devops #opensource

pgEdge Vectorizer: an open-source #PostgreSQL extension that automatically chunks text content and generates #vector embeddings using background workers.

Dave Page's latest blog "Building a RAG Server with PostgreSQL - Part 2: Chunking and Embeddings" walks you through how to use this extension to create a searchable vector database that can find relevant content based on context instead of exact keyword matching.

Check it out ➡️ https://www.pgedge.com/blog/building-a-rag-server-with-postgresql-part-2-chunking-and-embeddings

Part 3 coming soon!

#ai #llm #pgvector

Local to #Edinburgh? The next #PostgreSQL Edinburgh Meetup is this Thursday, December 11 and you'll be able to catch @vyruss delivering "RAGTime with Postgres: AI Power with pgvector and Retrieval-Augmented Generation".

It's bound to be a great deal of fun - register here if you'd like to attend: https://luma.com/b9kv5fds

Too far to join, but still want to learn about the topic? Let us know 💬

#scotland #postgres #devcommunity #rag #ai #pgvector #llm #aiengineering #programming #engineering

Now, you can use open-source pgEdge components designed for high-availability & multi-master replication combined with #CloudNativePG for cloud-native #PostgreSQL orchestration.

Our goal was to make it easy for developers to adopt powerful open-source and vendor lock-in free solutions.

How are you currently managing your Postgres deployments on Kubernetes? 💬

Find the full video on YouTube: https://www.youtube.com/watch?v=r442LvNxaoE

#postgres #kubernetes #cloudnative #devops #opensource #database #devcommunity

Did you miss it? The new pgEdge Control Plane is a 100% open source declarative API for managing Postgres clusters with flexible deployment options (like single-primary with failover replicas, and multi-zone active-active infrastructure).

You can also add logical nodes without downtime and use the API for quick and easy failover and switchover.

Read more about how it's used and how to install it on our blog: https://www.pgedge.com/blog/introducing-the-pgedge-control-plane-high-availability-postgres-simplified

#programming #coding #opensource #postgresql #postgres #foss

pgEdge's Dave Page took part in sharing big data and database/infrastructure predictions for 2026 in one of DBTA's latest articles. What changes would you like to see within the PostgreSQL project to shift how the project is currently run?

Check out his and other expert predictions for 2026, here: www.dbta.com/Editorial/News-Flashes/Experts-Give-8-Big-Data-Predictions-for-2026-172655.aspx

#programming #postgresql #postgres #data #opensource #devcommunity #dev #developer #bigdata #devops #tech

If you've ever wondered how to build your own RAG server with #PostgreSQL, now's your chance to learn. Dave Page kicks off a multi-part series on the topic in our latest blogpost, covering topics like..

⭐ Why PostgreSQL for RAG?
⭐ How to set up the database
⭐ How to install the document loader
⭐ Working with different source formats
⭐ Handling multiple documentation sets

..and much more.

Here’s the link to the first, stay tuned for the rest: https://www.pgedge.com/blog/building-a-rag-server-with-postgresql-part-1-loading-your-content

#ai #rag #llm #postgres

Snowflake sequences: for generating unique identifiers in #PostgreSQL, while avoiding conflicts and other errors that can occur when operating a multi-master database cluster.

It is now easier than ever to install using the pgEdge Control Plane, our Helm chart, our container images, or any other mode of installation for pgEdge Enterprise and Distributed #Postgres.

📖 Read more about it in our updated blog: https://www.pgedge.com/blog/introducing-snowflake-sequences-in-a-postgres-extension-2

#programming #opensource #developers #dev #data #k8s #kubernetes

We’re excited to share that pgEdge Enterprise Postgres has been named one of DBTA’s Trend-Setting Products in Data & Information Management for 2026.

This recognition reinforces our commitment to 100% open source, fully standard #PostgreSQL that provides organizations with the reliability, manageability, and enterprise-class support they need to scale #Postgres across demanding workloads.

Read the full list here: 🔗 https://www.dbta.com/Editorial/Trends-and-Applications/Trend-Setting-Products-in-Data-and-Information-Management-for-2026-172607.aspx?PageNum=6

#programming #opensource #tech #technology #developers

What happens when a conflict cannot be resolved in a distributed database system, such as when there's network or hardware failures?

Here, Paul Rothrock discusses how pgEdge handles duplicate or missing primary keys, and missed DDL statements.

Curious to know more about the snowflake sequences extension mentioned in the video? Find it on GitHub: https://github.com/pgEdge/snowflake

Find the full video on YouTube: https://youtu.be/prkMkG0SOJE

#programming #postgres #postgresql #dataarchitecture #software

Missed the live session? The on-demand version of the webinar given last week on “Building Always-on Postgres High Availability Across Clouds in Kubernetes” with our software engineers is now available!

pgEdge, CloudNativePG, and our updated Helm chart work together as a 100% open-source solution in #Kubernetes to simplify always-on #Postgres, high availability, and both multi region & multi-cloud operations.

👉 Watch on demand: https://pages.pgedge.com/postgres-series-building-always-on-postgres-high-availability-across-clouds-in-kubernetes



#programming #PostgreSQL #OpenSource

Get faster velocity in getting to market, peace of mind, and reliability in your database deployments with pgEdge Enterprise #Postgres. 🐘

All components are delivered under the permissive open-source #PostgreSQL license, and the Enterprise package ensures you get...

👉 tested and validated enterprise-grade builds,
👉 coordinated security updates,
👉 long-term maintenance, and
👉 optional 24x7 support subscription + troubleshooting guidance.

🌐 https://www.pgedge.com/products/what-is-pgedge-enterprise-postgres

#programming #opensource

A common concern where it comes to multi-master replication and distributed database systems is: how do you resolve or avoid conflicts and protect the integrity of your data?


pgEdge takes the approach of last-write wins (by default) but also implements conflict-free delta apply columns that allow you to apply all updates that take place when it’s needed.

See the full video to learn more about how pgEdge maintains data accuracy in a distributed PostgreSQL cluster: https://youtu.be/prkMkG0SOJE

Have you seen the pgEdge YouTube channel?

Find helpful tips & tricks, webinars, demos, and presentations on enterprise-worthy #Postgres topics like:

📹 multi-master (active-active) replication
📹 high availability
📹 scaling horizontally & vertically
📹 vector applications
📹 common #PostgreSQL mistakes
📹 and, of course, how to use pgEdge

Check it out and subscribe - new content weekly:

https://www.youtube.com/@pgEdge

#devcommunity #opensource #programming #tech #technology #dev #developers #data #sql

If you haven't heard of the new open-source pgEdge Control Plane (or you just want more details), our solution engineer Paul Rothrock walks through the secure API-based PostgreSQL orchestration system and all its features in our newest video on YouTube.

Use it to flexibly deploy single-region & multi-region #PostgreSQL along with a suite of high-impact #Postgres extensions & tools.

Take a look 👀 https://www.youtube.com/watch?v=yU-7nyKtiJk

#devcommunity #programming #developers #softwarearchitecture
#opensource

Did you know the b-tree skip scan capability was added as a query optimization improvement in Postgres 18? ✨

This allows the query planner to use multi-column indexes even when early columns lack equality restrictions - something that's especially useful for analytics and reporting workloads.

➡️ Find details about skip scan functionality in our latest blog: https://www.pgedge.com/blog/postgres-18-skip-scan-breaking-free-from-the-left-most-index-limitation

#programming #opensource #postgresql #postgres #tech #developers #devcommunity #data #datanalytics #engineering

It's time to simplify the management and orchestration of multiple #PostgreSQL clusters.

The pgEdge Postgres Control Plane provides a declarative API for defining, deploying, and updating databases across multiple hosts, giving you ultimate scalability and flexibility of deployments whether you're deploying across one region or many.

Get all the benefits of open source without a painful developer experience. Try it out: https://github.com/pgEdge/control-plane

#programming #postgres #databases #cloud #devops