Hacker News Reader

Comment by nik736 | Hacker News Reader

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

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

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.

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 ...

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

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

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.

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!

Reply on news.ycombinator.com