Hosted Providers

[ankane]

Add hosted providers that support pgvector to this thread.

Initial list:

• Supabase

[gregnr]

@ankane Funny, I was planning to send a PR shortly to request adding Supabase to the list. Been working with their team to get that integrated:
supabase/postgres#472

Thanks again for making a great extension. Currently using this to store and query OpenAI Embeddings.

[ankane]

Awesome, big thanks for adding it!

[m-abdelwahab]

Hey @ankane! Neon recently added support for pgvector: https://neon.tech/docs/release-notes/2023-02-14

[ankane]

Thanks @m-abdelwahab, great to hear!

[Winslett]

Crunchy Bridge

[george-bitdotio]

Howdy! bit.io now supports pgvector :)

[seanaguinaga]

Need that Google CloudSQL 8)

[Vonng]

Pigsty - Free RDS PG Alternative

now add pgvector as default extension in v2.0.2

[bbedward]

We added the extension to spilo to use with postgres-operator in kubernetes.

https://github.com/stablecog/spilo

Can just use the docker image in the helm chart values, or build your own:

https://hub.docker.com/r/stablecog/spilo

15.3+ has pgvector for Postgres 11-15

[pthieu]

fingers crossed for RDS 🤞

[mmmaia]

Render added support to their PostgreSQL service.

https://twitter.com/render/status/1646249514045702144

[gasabr]

yandex cloud provides an extension too https://cloud.yandex.com/en/docs/managed-postgresql/operations/extensions/cluster-extensions

[NicolasLopes7]

anyone has setup pg_vector on Railway? Didn't found anything about installing extensions there :/

[mmmaia]

anyone has setup pg_vector on Railway? Didn't found anything about installing extensions there :/

@NicolasLopes7 It's not possible yet. You can vote and comment on these feature requests:

• https://feedback.railway.app/feature-requests/p/install-postgres-extensions
• https://feedback.railway.app/feature-requests/p/pgvector-support

[mwmeyer]

No digital ocean hosted PG yet. Heres an upvote support request for others that want it: https://ideas.digitalocean.com/app-framework-services/p/saving-openai-embeddings-with-pgvector

[mfreed]

Timescale supports pgVector in its cloud offering.

[arjun810]

Available for RDS now! https://aws.amazon.com/about-aws/whats-new/2023/05/amazon-rds-postgresql-pgvector-ml-model-integration/

[Bacto]

Hi!

pgvector is available on Stackhero PostgreSQL cloud hosting solution with PostgreSQL 15 🥳🥳🥳

[Bacto]

And it is also available for Heroku via Stackhero PostgreSQL add-on 👌

[montanalow]

Also available on hosted PostgresML databases.

[mulander]

pgvector is now available on Azure:

• Azure Database for PostgreSQL Flexible Server

Follow this page to enable vector in the allowed extensions and then simply CREATE EXTENSION vector; on your Flexible Server.

• Azure Cosmos DB for PostgreSQL

Just connect to your cluster and issue SELECT create_extension('vector');

Main readme update submitted as #129

[jcoc611-gvt]

@mulander Seems like extension vector is not yet available in Azure Flexible Server (also not present in this doc). Do you know when it will be in general availability?

[mulander]

@mulander Seems like extension vector is not yet available in Azure Flexible Server (also not present in this doc). Do you know when it will be in general availability?

@jcoc611-gvt What region are you checking and is it on a new or deployed cluster? The documentation update (including the doc you linked) is scheduled to be published on the 23rd of May.

[louis030195]

https://github.com/different-ai/embedbase hosted version uses pgvector in supabase :)

[mareksuscak]

It seems to me that Google has recently secretly added support for pgvector 0.4.2 in POSTGRES_15_2.R20230530.01_00 maintenance update! The list of extensions in the documentation has not been updated yet to reflect this but running SELECT * FROM pg_available_extensions; on a recently updated Cloud SQL instance shows this:

Yas!

[packi]

We've added pgvector to our supported extensions at Aiven, starting from PG13, see https://docs.aiven.io/docs/products/postgresql/reference/list-of-extensions. You may need to apply a maintenance upgrade to get it in your existing service.

[nikhilshinday]

anyone have an update on Aurora pgvector support on RDS?

[guillim]

It seems to me that Google has recently secretly added support for pgvector 0.4.2 in POSTGRES_15_2.R20230530.01_00 maintenance update! The list of extensions in the documentation has not been updated yet to reflect this but running SELECT * FROM pg_available_extensions; on a recently updated Cloud SQL instance shows this:

Yas!

It’s now in the official documentation !!!

[developeralim]

I faced this issue when i was installing pgvector. i am using windows 10 . can anyone help me please

[pabloem]

Also Google's AlloyDB has added support for PGVector: https://cloud.google.com/blog/products/databases/announcing-vector-support-in-postgresql-services-to-power-ai-enabled-applications

[enchorb]

+1 pgvector for AWS Aurora

[disbelief]

So I guess this announcement from AWS on May 3 about pgvector support doesn't apply to Aurora? https://aws.amazon.com/about-aws/whats-new/2023/05/amazon-rds-postgresql-pgvector-ml-model-integration/

[enchorb]

Correct, pgvector works on Amazon RDS for PostgresSQL but not on Amazon Aurora PostgresSQL.

[retendo]

Although it is not documented, this seems to work on DigitalOcean Managed Postgres as well now. At least with Postgres 15. It didn't work with Postgres 12 though.

[ganesh-rao]

I believe AWS now supports pgvector on Aurora PostgresSQL:

https://docs.aws.amazon.com/AmazonRDS/latest/AuroraPostgreSQLReleaseNotes/AuroraPostgreSQL.Updates.html#AuroraPostgreSQL.Updates.20180305.153X

It's also listed here for Postgres 15.3:
https://docs.aws.amazon.com/AmazonRDS/latest/AuroraPostgreSQLReleaseNotes/AuroraPostgreSQL.Extensions.html#AuroraPostgreSQL.Extensions.15

[schoblaska]

DigitalOcean now lists pgvector on their page of supported extensions (for PostgreSQL 13 and newer): https://docs.digitalocean.com/products/databases/postgresql/details/supported-extensions/

[amadeus633]

I believe AWS now supports pgvector on Aurora PostgresSQL:

https://docs.aws.amazon.com/AmazonRDS/latest/AuroraPostgreSQLReleaseNotes/AuroraPostgreSQL.Updates.html#AuroraPostgreSQL.Updates.20180305.153X

It's also listed here for Postgres 15.3: https://docs.aws.amazon.com/AmazonRDS/latest/AuroraPostgreSQLReleaseNotes/AuroraPostgreSQL.Extensions.html#AuroraPostgreSQL.Extensions.15

Do you know if this includes Postgres on AWS Lightsail?

[StubbornDeer]

AWS Postgres 14: https://docs.aws.amazon.com/AmazonRDS/latest/PostgreSQLReleaseNotes/postgresql-extensions.html#postgresql-extensions-14x

[vishnu-narayanan]

AWS Postgres 13: https://docs.aws.amazon.com/AmazonRDS/latest/PostgreSQLReleaseNotes/postgresql-extensions.html#postgresql-extensions-13x

[shayons]

The pgvector extension is available on Aurora PostgreSQL as of July 13 (https://aws.amazon.com/about-aws/whats-new/2023/07/amazon-aurora-postgresql-pgvector-vector-storage-similarity-search) on versions 15.3, 14.8, 13.11, 12.15 and higher. Here's a blog that shows you how to build an AI powered chat bot application and perform sentiment analysis using pgvector and Amazon Aurora PostgreSQL - https://aws.amazon.com/blogs/database/leverage-pgvector-and-amazon-aurora-postgresql-for-natural-language-processing-chatbots-and-sentiment-analysis/

[ClearedFram3]

(off topic) @guillim is the GUI you show something from google cloud or a standalone product?

[jdowning]

Heroku Postges supports pgvector:

• Add support for pgvector to Heroku Postgres heroku/roadmap#156
• https://devcenter.heroku.com/changelog-items/2687

[jcrupi]

Looks like Azure Postgres Flex Server only supports pgvector .4,0

[gulcin]

EDB's BigAnimal Postgres-as-a-Service supports pgvector:

• https://www.enterprisedb.com/blog/what-is-pgvector

BigAnimal is EDB’s managed Postgres service that allows you to run Postgres on all major cloud platforms. Now, you can enable pgvector on your databases and start experimenting!

[MSuter6]

Northflank now also supports pgvector with its PostgreSQL addon offering: https://northflank.com/docs/v1/application/databases-and-persistence/deploy-databases-on-northflank/deploy-postgresql-on-northflank#postgresql-specifications.

[Kikiodazie]

Hey everyone, Severalnines' ClusterControl now also supports pgvector in its PostgreSQL offering.

See how here: https://docs.severalnines.com/docs/knowledgebase-tutorials/clustercontrol/tutorials/deploying-postgresql-cluster-with-pgvector-extension/.

[nicholasdly]

pgvector is supported on Railway via the community made pgvector project template, which has been updated to the latest version today!

(Thanks @brody192!)

edit: incorrectly called the template an "official" template

[brody192]

thanks for the shout-out, but I feel it necessary to point out that it's not official, it's not published by Railway or pgvector themselves, I'm just a Railway community member :)

[ikoif]

The Heroku Postgres add-on seems to support it for tiers starting from standard.

[fijiwebdesign]

https://nexai.site now supports pgvector as a projects semantic database.