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