Is there a recommended way to get pgvector on RDS?

[pfaffman (Jay Pfaffman)]

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 PG14. I think this site is running on RDS, though.

Presumably typical self-hosters won’t have this problem as the current database image has pgvector, but both of the places I wanted to try this are running other pg installs.

[Falco]

@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 on PG 13.11 in there

@pfaffman

Presumably typical self-hosters won’t have this problem as the current database image has pgvector, but both of the places I wanted to try this are running other pg installs.

pgvector is available in AWS RDS, Aurora, Azure, GCP and Digital Ocean hosted PostgreSQL services, so I think this won’t be a problem.

[pfaffman (Jay Pfaffman)]

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

Thanks.

[Falco]

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

[pfaffman (Jay Pfaffman)]

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.

[Falco]

@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

[pfaffman (Jay Pfaffman)]

@Falco

that wasn’t really strict for copy and paste

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

[image] Uncaught (in promise) TypeError: Cannot read properties of undefined (reading 'privateMessage') at shouldRender (ai-helper-context-menu.js:48:1) at plugin-connectors.js:185:1 at Array.filter (<anonymous>) at e.renderedConnectorsFor (plugin-connectors.js:183:1) at get connectors [as connectors] (plugin-outlet.js:126:1) at Ce (index.js:1251:1) at reference.js:175:1 at reference.js:136:1 at e.track (validator.js:668:1) at f (reference.js:135:1) a…

[merefield (Robert)]

@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?

[Falco]

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.

[Will_Grosett]

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;