Pinecone ships pg_pinecone, an open-source Postgres vector extension
A new Postgres extension built on Pinecone's own search engine claims smaller indexes and better filtered-search accuracy than pgvector, and runs entirely inside your database with no API key needed.