Is there a recommended way to get pgvector on RDS? this page claims: The pgvector extension is available on all database instances in Amazon RDS running PostgreSQL 15.2 and higher in all AWS Regions, including the AWS GovCloud (US) Regions. But last I knew, there was some subtle problem with PG…

[صورة] Jay Pfaffman: But last I knew, there was some subtle problem with PG14. I think this site is running on RDS, though. We fixed it! Meta has been running PG15 for 3 months or so. (brace for the self-hosted pg upgrade soon) But while AWS doesn’t tell you upfront, you also have pgvector o…

[صورة] Falco: We fixed it! Meta has been running PG15 for 3 months or so. Cool. That’s good to know. Thanks. That’ll solve one problem. The other is a self-installed postgres image that does replication. Maybe I can figure out how to use the Discourse image and get replication working with it…

[صورة] Jay Pfaffman: The other is a self-installed postgres image that does replication. pgvector is on the Ubuntu/Debian official PostgreSQL PPAs, so after having that enabled it’s a simple apt install pgvector away in any server / image you have access to.

Sigh. Strangely the postgres:13 docker image doesn’t solve the problem with apt as suggested. It seemed like the official pg image would be a safe way to go.

[صورة] Jay Pfaffman: Strangely the postgres:13 docker image doesn’t solve the problem with apt as suggested. Sorry that wasn’t really strict for copy and paste, the exact command would be apt update && apt install postgresql-${PG_MAJOR}-pgvector

[صورة] Falco: that wasn’t really strict for copy and paste :person_facepalming: LOL. Thanks, my postgres and its replica are now updated and I installed it! Now for bug reports. [صورة] Cannot access group profile page with AI plugin Support [image…

[صورة] Falco: Meta has been running PG15 for 3 month Now if memory serves me, that’s around the time you tend to deploy it to us standard install types. Do you have a planned roll out schedule for PG15 in mind?

Yes, taking into account the last few times we should be introducing that upgrade in this or the next quarter indeed. Still, we have not started the self-hosting upgrade rollout yet.

For the benefit of others - to get pg_vector on AWS RDS 13.x I ran the following as admin in pgadmin: CREATE EXTENSION vector;

هل هناك طريقة موصى بها للحصول على pgvector على RDS؟

الدعم تثبيت

pfaffman (Jay Pfaffman) 23 أغسطس 2023، 7:49م 7

لول. شكرًا، تم تحديث قاعدة بيانات Postgres الخاصة بي ونسختها وقمت بتثبيتها! الآن لتقارير الأخطاء.

الموضوع		الردود	مرات العرض
Dev migration error: PGVector Development	6	248	28 يوليو 2025
Extension "vector" has no update path from version "0.4.1" to version "0.7.0" (PG::InvalidParameterValue) Self-hosting	3	208	12 أغسطس 2024
Is it safe to upgrade pgvector to 0.8.0 before running migration 20251007123645? Self-hosting	1	87	23 فبراير 2026
Still an issue: ERROR: must be owner of extension vector Support ai	2	633	3 ديسمبر 2024
Bootstrap error with ai plugin, bundle exec rake db:migrate Support ai	5	200	23 يوليو 2025

هل هناك طريقة موصى بها للحصول على pgvector على RDS؟

الموضوعات ذات الصلة