PgEdge Goes Open Source

https://www.pgedge.com/blog/pgedge-goes-open-source

126•Bogdanp•4mo ago

Comments

nik736•4mo ago

Anyone has any experience with PgEdge and can tell us about reliability? :-)

Daril•4mo ago

I wanted to try it months ago ... but I stopped when I read in the install documentation :

To configure passwordless sudo, open the /etc/sudoers file, and add a line of the form: %username ALL = (ALL) NOPASSWD: ALL

And the same user should have a password less SSH access with private key ...

0x6c6f6c•4mo ago

It could do better for sure, but it's a just a Get Started guide, I never consider that a Production Ready guide.

Valodim•4mo ago

Honest question, what's the problem with that? Hinging admin access for some machine on an ssh key seems like not too unusual practice?

Daril•4mo ago

From a security point of view, I am not comfortable giving a user unlimited access to the server. I don't know what solution pgEdge is implementing, but granting full access to the server when it should only operate on PostgreSQL is a security concern for me.

pgedge_postgres•4mo ago

the Getting Started guide is definitely a different mindset than what we would recommend for Production Ready, particularly if there's specific security requirements in mind. With that being said, it should be more clear, so we've reported this to our documentation team to make sure it is!

emarsden•4mo ago

They have an open issue concerning a SIGILL when loading the pgvector extension that hasn't been fixed or seen any activity in a month.

   https://github.com/pgEdge/pgedge-docker/issues/20

pgedge_postgres•4mo ago

Thanks for flagging this. You’re right that the issue sat too long without a response, and that’s on us. We’ve now replied on GitHub and are actively looking into it. It appears the crash may be related to CPU feature mismatches (e.g. missing AVX support when using pgvector), especially in emulated environments like ARM Macs running x86 containers. We’ve asked for system details to help confirm. Happy to dig in and resolve it quickly from here.

kstrauser•4mo ago

And under the PostgreSQL license, an actual OSI approved one, not a fake open source in name only monstrosity. Very nice!

hxtk•4mo ago

If you're referring to the post from yesterday, they actually relicensed it as Apache 2.0: https://news.ycombinator.com/item?id=45196173

kstrauser•4mo ago

No, I had in mind different recent announcements when companies selected closed licenses that let you look at the code but not actually use it, then bragged about open sourcing their project.

DetroitThrow•4mo ago

Announcement title and actual license divergence has made reading these announcements a bit of a chore on HN since you're required now to read the full post. Good on these guys for not open washing their project.

And of course it doesn't help the tedium of reading HN that there's 5 very vocal commentators who want to the world to know that "OSI doesn't own the definition of open source", even though when asked will define open source as "can be commercially restricted".

pgedge_postgres•4mo ago

We definitely really appreciate how open source leads to real innovation and actually useful code; no intention of openwashing here. Thank you for noticing that :-)

tw04•4mo ago

I think it’s great they’re opening it up. I hope they have a plan to defend when the hyperscalers show up to pillage beyond providing cloud containers and VMs as a paid service.

atombender•4mo ago

Weird, I posted this yesterday, why didn't HN detect the duplicate? https://news.ycombinator.com/item?id=45203769

WolfOliver•4mo ago

Your's has to little upvotes. I think it is only detected as duplicate if it had made the front page in the last few months.

atombender•4mo ago

Hm, I've had my submissions deduped before, where the existing post also had few upvotes and was definitely not on the front page.

hu3•4mo ago

same

darqis•4mo ago

I can't tell what it actually is. Too much marketing babble

eXpl0it3r•4mo ago

> pgEdge is a modern distributed database system built on standard PostgreSQL that’s designed for geo-distribution, high availability, and low latency — especially useful for "edge" deployments.

Had to look elsewhere as well...

jmholla•4mo ago

Also, in that same vein of caginess, they don't call out their pricing. It's one of those, "contact sales" services.

benjiro•4mo ago

YugabyteDB / CockroachDB like from that description. Curios to see how it competes with multigres.

pgedge_postgres•4mo ago

We're a little different in that we're not just 100% open-source, but also 100% compatible with community PostgreSQL. see https://pgscorecard.com for comparisons between pgEdge and YugabyteDB, CockroachDB on that front.

More thoughts on why we feel that's important here: https://www.pgedge.com/blog/considering-distributed-postgres...

and the Buyer's Guide (https://www.pgedge.com/landing-pages/distributed-postgresql-...) referenced within does list more technical details and comparisons between us and YugabyteDB / CockroachDB.

qaq•4mo ago

They really need to dial back on marketing bs. async multimaster takes away consistency. Piling on NewSQL DBS for slow synchronous writes to a quorum of nodes WTF?

pgedge_postgres•4mo ago

async multi-master does trade off consistency for availability and latency. In PACELC terms, pgEdge leans into AP/EL, not CP. It’s built for low-latency local writes across regions, with built-in conflict resolution to manage eventual consistency. Definitely not trying to be a NewSQL quorum-write system. Just a different use case.

justinclift•4mo ago

This is good news. :)

pgedge_postgres•4mo ago

agreed!! :-)

bigwheels•4mo ago

I appreciate the open source foundation! Is the goal of pgEdge functionally aligned or divergent from what CitusDB offers?

pgedge_postgres•4mo ago

Thanks for the feedback! We're pretty excited about it, too :-)

Citus focuses on scaling Postgres via sharding, typically with a single write node and many read replicas. It’s great for high-throughput, analytical workloads. pgEdge, by contrast, is built for geo-distributed, multi-master Postgres — all nodes are writable, with built-in conflict resolution. It prioritizes low latency, availability, and data locality over pure scale-out. So the goals are pretty different.

ksec•4mo ago

Is PgEdge Vitess of MySQL ?

I assume given there are two Vitess for Postgres being worked on now they have decided to open source it?

pgedge_postgres•4mo ago

pgEdge came about from a pglogical foundation, actually! from one of our blogs:

> pgEdge emerged in late 2024 as a serverless distributed Postgres managed cloud service, delivering low latency and high availability in three minutes or less. The pgEdge Platform (for on-premises distributed PostgreSQL) as well as pgEdge Cloud (for deploying in the cloud) was largely inspired by the original capabilities of the pgLogical extension.

https://www.pgedge.com/blog/navigating-distributed-postgresq...

OpenCiv3: Open-source, cross-platform reimagining of Civilization III

The Waymo World Model

How we made geo joins 400× faster with H3 indexes

Show HN: Look Ma, No Linux: Shell, App Installer, Vi, Cc on ESP32-S3 / BreezyBox

Monty: A minimal, secure Python interpreter written in Rust for use by AI

Unseen Footage of Atari Battlezone Arcade Cabinet Production

Show HN: I spent 4 years building a UI design tool with only the features I use

Microsoft open-sources LiteBox, a security-focused library OS

Dark Alley Mathematics

Sheldon Brown's Bicycle Technical Info

Hackers (1995) Animated Experience

Delimited Continuations vs. Lwt for Threads

Show HN: If you lose your memory, how to regain access to your computer?

PC Floppy Copy Protection: Vault Prolok

An Update on Heroku

What Is Ruliology?

How to effectively write quality code with AI

Why I Joined OpenAI

Show HN: ARM64 Android Dev Kit

Female Asian Elephant Calf Born at the Smithsonian National Zoo

Learning from context is harder than we thought

Show HN: R3forth, a ColorForth-inspired language with a tiny VM

I spent 5 years in DevOps – Solutions engineering gave me what I was missing

Introducing the Developer Knowledge API and MCP Server

Understanding Neural Network, Visually

I now assume that all ads on Apple news are scams

Zlob.h 100% POSIX and glibc compatible globbing lib that is faste and better

FORTH? Really!?

Show HN: Smooth CLI – Token-efficient browser for AI agents

WebView performance significantly slower than PWA

OpenCiv3: Open-source, cross-platform reimagining of Civilization III

The Waymo World Model

How we made geo joins 400× faster with H3 indexes

Show HN: Look Ma, No Linux: Shell, App Installer, Vi, Cc on ESP32-S3 / BreezyBox

Monty: A minimal, secure Python interpreter written in Rust for use by AI

Unseen Footage of Atari Battlezone Arcade Cabinet Production

Show HN: I spent 4 years building a UI design tool with only the features I use

Microsoft open-sources LiteBox, a security-focused library OS

Dark Alley Mathematics

Sheldon Brown's Bicycle Technical Info

Hackers (1995) Animated Experience

Delimited Continuations vs. Lwt for Threads

Show HN: If you lose your memory, how to regain access to your computer?

PC Floppy Copy Protection: Vault Prolok

An Update on Heroku

What Is Ruliology?

How to effectively write quality code with AI

Why I Joined OpenAI

Show HN: ARM64 Android Dev Kit

Female Asian Elephant Calf Born at the Smithsonian National Zoo

Learning from context is harder than we thought

Show HN: R3forth, a ColorForth-inspired language with a tiny VM

I spent 5 years in DevOps – Solutions engineering gave me what I was missing

Introducing the Developer Knowledge API and MCP Server

Understanding Neural Network, Visually

I now assume that all ads on Apple news are scams

Zlob.h 100% POSIX and glibc compatible globbing lib that is faste and better

FORTH? Really!?

Show HN: Smooth CLI – Token-efficient browser for AI agents

WebView performance significantly slower than PWA

PgEdge Goes Open Source

Comments