pgvector in Bitnami Postgres

[nerdeveloper]

Name and Version

bitnami/postgres:latest

What architecture are you using?

amd64

Additional information

Hello Team, I wanted to ask if pgvector is supported in bitnami Postgres https://github.com/pgvector/pgvector

if not, when will this be out, please?

[jotamartos]

That extension is not included by default, but you can easily install it in the container (using the root user )

install_packages git build-essential
cd /tmp
git clone --branch v0.4.1 https://github.com/pgvector/pgvector.git
cd pgvector
export PG_CONFIG=/opt/bitnami/postgresql/bin/pg_config
make
make install

and then connect to the database and load it

postgres=# CREATE EXTENSION vector;
CREATE EXTENSION
postgres=# \dx
                        List of installed extensions
  Name   | Version |   Schema   |                Description
---------+---------+------------+--------------------------------------------
 plpgsql | 1.0     | pg_catalog | PL/pgSQL procedural language
 vector  | 0.4.1   | public     | vector data type and ivfflat access method
(2 rows)

postgres=#

[github-actions]

This Issue has been automatically marked as "stale" because it has not had recent activity (for 15 days). It will be closed if no further activity occurs. Thanks for the feedback.

[github-actions]

Due to the lack of activity in the last 5 days since it was marked as "stale", we proceed to close this Issue. Do not hesitate to reopen it later if necessary.

[philippemnoel]

Any suggestions on how to install extensions which aren't TLEs? Specifically that would get the error "ERROR: permission denied for language c"

[coronabytes]

For anyone finding this thread and wants the easy solution...

FROM pgvector/pgvector:pg16 AS builder

FROM bitnami/postgresql-repmgr:16

COPY --from=builder /usr/lib/postgresql/16/lib/vector.so /opt/bitnami/postgresql/lib/
COPY --from=builder /usr/share/postgresql/16/extension/vector* /opt/bitnami/postgresql/share/extension/